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.
Hi v-karpurapud
Thank you for suggesting Power Automaten. Since the use case is creating a backup of the pbix file, any other file format is not useful.
Is there also a way to down the pbix file from My Workspace using Power Automate?
Kind regards,
Martin
Hi Martin_D
To download a PBIX file from "My Workspace" using Power Automate, please follow these steps:
1. Create a new flow in Power Automate and add a trigger to initiate the flow.
2. Include the "HTTP" action to make an API call and configure it as follows:
- Method: GET
- URI: https://api.powerbi.com/v1.0/myorg/reports/{reportId}/Export
- Headers:
- Authorization: Bearer {access_token}
- Content-Type: application/json
- Replace {reportId} with the ID of the report you wish to export.
3. Add an action to save the exported file to a designated location (e.g., OneDrive, SharePoint, or send it via email).
Ensure you have the necessary permissions and access tokens to perform this action. This method should enable you to download the PBIX file from "My Workspace."
If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thank You.
Hi v-karpurapud ,
Thank you for sharing your idea. I tried it, and it does not work. Since I'm using the same identity and the same API call like in PowerShell, I do wonder how should doing the same in Power Automate solve the issue?
I could imagine that with a build in action this could be possible, because with other Microsoft products, the Power Automate actions also use undocumented APIs, but I didn't find any action for download reports. Do you know of any suitable action or undocumented Power BI API to download reports from My Workspace?
Kind regards,
Martin
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.