Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Thanks
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.
pls, let me if it still applies.
Thanks
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.
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
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.
Are these requirements also applicable on the EXPORT API you mentioned before?
Thanks,
Arij
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
17 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |