topic Re: PowerBI Report Export in csv format via Rest API in Developer

PowerBI Report Export in csv format via Rest API

kehamparam1 — Thu, 03 Sep 2020 10:58:34 GMT

Hi,

PowerBI provided CSV format export API for Paginated Reports alone, not for normal reports which support only pbix, ppt, png formats.

Reference: https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile

Is there any API to export PowerBI reports in CSV format?

If not, is there any API to get the exact data present in a particular report?

Can you please help me with a solution/clarity on this since am looking for it for a long time.

Re: PowerBI Report Export in csv format via Rest API

Greg_Deckler — Thu, 03 Sep 2020 11:02:15 GMT

@kehamparam1 - That is only supported for paginated reports, I do not know of any way to get a CSV of a report.

Re: PowerBI Report Export in csv format via Rest API

kehamparam1 — Thu, 03 Sep 2020 11:23:20 GMT

Thank you @Greg_Deckler

In that case, is there any api to retrieve direct data from a powerbi report or from a powerbi dataset ?

Not the metadata, the actual data which we have mapped to be shown in the report.

Re: PowerBI Report Export in csv format via Rest API

Greg_Deckler — Thu, 03 Sep 2020 11:36:31 GMT

@kehamparam1 - I was looking at the REST API and I couldn't find anything 😞

Re: PowerBI Report Export in csv format via Rest API

Anonymous — Tue, 08 Sep 2020 09:11:15 GMT

Hi @kehamparam1,

It seems like you are searching for programming functions to export power bi content as same as power bi export features.

Export the data that was used to create a visualization

As Greg_Deckler said, current power bi seems not to release these features to Power bi REST API.

If you still want to achieve these, I think you need to trace and analytic the power bi export features to find out the 'request url', header, correspond request tokens, and parameters. Then you can simulation these operations based on scripts or programming languages. (notice: these operations obviously complex than developing on rest api and they required you are familiar with using programming language/script on web development)

In my opinion, I'd like to suggest you submit ideas to add more export APIs.

Regards,

Xiaoxin Sheng