topic Re: Downloading Data Sets via Power BI REST API? in Developer

Downloading Data Sets via Power BI REST API?

Sana_Syed — Fri, 27 Dec 2019 08:41:53 GMT

Hello.

I wanted to know if there is a way to download datasets via the Power BI Rest API that were uploaded to Power BI? I went through the documentation but couldnot find any endpoint to do so. Any help or guideline is appreciated.

Regards.

Re: Downloading Data Sets via Power BI REST API?

v-qiuyu-msft — Mon, 30 Dec 2019 05:48:42 GMT

Hi @Sana_Syed,

Currently, we are not able to download the dataset separately. However, we can download the pbix file from Power BI service via REST API:

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

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

Best Regards,
Qiuyun Yu

Re: Downloading Data Sets via Power BI REST API?

Sana_Syed — Mon, 30 Dec 2019 07:20:21 GMT

Hello, @v-qiuyu-msft ,

Thank you for the response. It was helpful. Although, i was reading about this feature over at the Microsoft Docs and found the following:

There are a few important considerations and limitations associated with downloading a .pbix file from the Power BI service.

To download the file, you must have edit access to the report.
The report must have been created by using Power BI Desktop and published to the Power BI service, or the .pbix file must have been uploaded to the Power BI service.
Reports must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.
This feature won't work with reports and content packs originally created in the Power BI service.
Always use the latest version of Power BI Desktop when you open downloaded files. Downloaded .pbix files might not open in non-current versions of Power BI Desktop.
If your administrator has turned off the ability to download data, this feature won't be visible in the Power BI service.
Datasets with incremental refresh can't be downloaded to a .pbix file.

Are these requirements also applicable on the EXPORT API you mentioned before?

Regards.

Re: Downloading Data Sets via Power BI REST API?

v-qiuyu-msft — Tue, 31 Dec 2019 06:51:56 GMT

Hi @Sana_Syed,

Based on my test, the limitations apply to API as well.

Best Regards,
Qiuyun Yu