Pankaj Surti's Blog


Home | About Me | Archives


Download Power BI visual data as CSV or JSON

April 15, 2020 11:29 AM

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

 

Posted by Pankaj

Categories: Uncategorized

Tags:

Leave a Reply



Mobile Site | Full Site


Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.