Forum Discussion
Download report from "My Workspace" using REST API?
Hi Martin_D
I understand that the implementation did not work as expected.Currently, there isn't a specific documented or undocumented API for downloading reports from "My Workspace".
- Power BI APIs are generally more optimized for organizational workspaces rather than My Workspace. This can cause unexpected issues or limited functionality when trying to automate tasks for reports stored in My Workspace.
- Consider migrating the report to an organizational workspace to potentially resolve this issue.
If the issue persists, please consider raising a Microsoft support ticket for further assistance.Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
If my response has resolved your query, please mark it as the Accepted Solution to help others. Additionally, I would appreciate a 'Kudos' if you found my response helpful.
Thank You.
Are you sure about that? According to the API documentation, there are two different ones, where one provides access to My Workspace, and the other does not:
GET https://api.powerbi.com/v1.0/myorg/reports/{reportId}/Export
Exports the specified report from My workspace to a Power BI .pbix or .rdl file.
GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}/Export
Exports the specified report from the specified workspace to a Power BI .pbix or .rdl file.
You can run any REST API from PowerShell, for example, using Invoke-RestMethod.
Hi mariussve1 ,
Thank you for sharing this idea.
I tried, but when I authenticate with the user that owns the My Workspace containing the report I still get 403 forbidden.
Maybe this would be doable with a service principal with Admin consent? Unfortunatelly I don't have one to try myself.
Kind regards,
Martin