CODEWITHSUNDEEP
powerbipowerbi-embeddedpower-bi-report-server
welu
welu

Reputation: 339

How can we Export data from Web Published Reports

I have published an application that i did with power Bi, for some charts I want to make data downloadable for users.

I couldn't find any straight forward way to do that, some sites talk about implementing a script for that.

Is there any real way for published application that works?

Upvotes: 0

Views: 2128

Answers (1)

Andrey Nikolov
Andrey Nikolov

Reputation: 13460

One of the limitations of Publish to web is the inability to export data:

  • Reports using row level security.
  • Reports using any Live Connection data source, including Analysis Services Tabular hosted on-premises, Analysis Services Multidimensional, and Azure Analysis Services.
  • Reports shared to you directly or through an organizational content pack.
  • Reports in a group in which you are not an edit member.
  • "R" Visuals are not currently supported in Publish to web reports.
  • Exporting Data from visuals in a report, which has been published to the web
  • ArcGIS Maps for Power BI visuals.
  • Reports containing report-level DAX measures.
  • Single sign-on data query models.
  • Secure confidential or proprietary information.
  • The automatic authentication capability provided with the Embed option doesn't work with the Power BI JavaScript API. For the Power BI JavaScript API, use the user owns data approach to embedding. Learn more about user owns data.

Exporting data is possible, if you publish your report in Power BI Online and share it with your colleagues. But keep in mind, that even in this case it may not be possible or allowed, due to these limitations, e.g. if it has been disabled, or the user doesn't have enough permissions. In addition, it has limits on maximum columns, rows and data size.

The best option is to export the data directly from the data source, which is used to build this report.

Upvotes: 2

Related Questions