Downloading Data Sets via Power BI REST API?

[arijsiddiqui]

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 could not find any endpoint to do so. May I know is there any way?

Regards.

[arijsiddiqui]

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 could not find any endpoint to do so. May I know is there any way?

Regards.

[arijsiddiqui]

Hi,

Thanks for your response, I have gone through the documentation "https://docs.microsoft.com/en-us/power-bi/create-reports/service-export-to-pbix#download-the-report-...  it says that it has some limitations so does it still apply to API also. ?

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.

Thanks

[arijsiddiqui]

One more query to ask,
I have found two rest APIs to download the datasets which are:

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

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

Now these APIs have some requirements mentioned below, are they still apply to these APIs^.

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.

pls, let me if it still applies.

Thanks

[v-shex-msft]

Hi @arijsiddiqui,

REST API seems not provide the interface to export report dataset. For this scenario, you can download the report file and use ssms/excel to connect to the internal data model and do export operations.

Power bi data model instance 

In addition, power bi service saving the datasets into the azure blob storage, you can also try to export data from that data source.

How to access data from Azure Blob Storage using Power BI (sqlshack.com)

Regards,

Xiaoxin Sheng

[arijsiddiqui]

Hi @v-shex-msft 

Thanks for your response, after reading the documentation about this feature found some limitations attach to this feature.

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?

Thanks,

Arij

[v-shex-msft]

Hi @arijsiddiqui,

Export API seems use the same interface that 'down pbix file' feature used, so I think these limitations should also apply to export API.

Regards,

Xiaoxin Sheng