uli on 11 Jan 2021 10:53:45
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?
- Comments (2)
RE: Allow Export Dataset via REST API
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.
RE: Allow Export Dataset via REST API
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!!!