Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Allow Export Dataset via REST API

As of now we can scan Tenants for changes via the REST API. The scan results contain Reports and Datasets. To get the Dataset one can call the /reports/{id}/export endpoint to get the pbix file - no problem. The problem arises when I delete the published report in power bi service (the dataset still remains). From the powerbi service UI I can still click on the dataset and download a pbix file that contains the dataset and an empty report. But from the rest API I can now no longer download the dataset as pbix file as I only have the dataset id but I need the report id (which does no longer exist). I checked and the powerbi UI calls a totally different api endpoint to download the pbix of a dataset. Is there something I'm missing or is it currently not possible to export the .pbix file of a published dataset who's report was deleted?
Status: Needs Votes
Comments
fbcideas_migusr
New Member
https://docs.microsoft.com/en-us/rest/api/power-bi/admin/dataflows_exportdataflowasadmin?source=docs This to expose the pbi:mashup data!!! Required to gain visibility of Dataset health and associated troubleshooting of powerquery code for teanancy admins. PLEASE!!!
Alex_Gorbunov
New Member
Exporting of the standalone dataset is not working via PowerShell too. We can download .PBIX of the report, connected to a Power BI Dataset using powershell "Export-PowerBIReport". But it doesn't support downloading of the dataset if there is no report that is bound to it. It seems that the only option at the moment is to manually download the dataset from Power BI service. Please improve Power BI REST API and PowerShell capabilities to download Reports, Dataflows and Datasets.
fbcideas_migusr
New Member
Status changed to: Needs Votes