Skip to main content

Power BI

New

Improve PowerShell and REST API to work with standalone Datasets

Vote (1) Share
Alex Gorbunov's profile image

Alex Gorbunov on 16 Nov 2021 08:53:56

Scenario:
1. Create a new report in PBI Desktop, publish it to the workspace. It creates a dataset and a report.
2. Remove the report from the workspace. The dataset remains as-is and can still be used as a data source for other reports.
3. Try downloading the .PBIX file of the dataset. You can do it manually from the workspace in the browser. But you can't do this using PowerShell or REST API. PowerShell command Export-PowerBI doesn't work if there is no report bound to the dataset, same with REST API.

Please improve PowerShell and REST API to support working with standalone datasets.

Comments (1)
Alex Gorbunov's profile image Profile Picture

James Bartlett on 12 Apr 2024 20:51:48

RE: Improve PowerShell and REST API to work with standalone Datasets

Here's a PowerShell script I wrote, which can export "standalone" or "thin" semantic models (formerly known as "datasets") from Power BI:https://github.com/JamesDBartlett3/PowerBits/blob/main/PowerShell/Scripts/Export-PowerBIThinModelsFromWorkspaces.ps1Give it a try and let me know if it works out for you.