Download Power BI visual data as CSV or JSON

My customer had a requirement to download the Summary data of the report visual for Power BI embedded report.

I went to achieve this as a wrong path first. I hope you don’t do the same mistake.

The path I first took was to use the REST API below.
Datasets – Get Dataset -> https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdataset

Push Datasets – Datasets GetTables -> https://docs.microsoft.com/en-us/rest/api/power-bi/pushdatasets/datasets_gettables

DO NOT use those APIs to get the dataset of an existing report. This will not work. These APIs only work for the data you pushed via API. The data set will show the API ACCESS as shown below.

PowerBIAPIAccess To download embedded report data use the Power BI client JS api to download.

Export Data-> https://github.com/microsoft/PowerBI-JavaScript/wiki/Export-Data

 

About Pankaj

I am a Developer and my linked profile is https://www.linkedin.com/in/pankajsurti/
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s