Forum Discussion

Martin_D's avatar
Martin_D
Solution Sage
1 year ago
Solved

Download report from "My Workspace" using REST API?

Hi, Is there a way to download reports from "My Workspace" using REST API? What would be the exact syntax in PowerShell?   If I authenticate at Connect-PowerBIServiceAccount with my user, I can...
Need Help
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    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.

mariussve1's avatar
mariussve1
Solution Sage
1 year ago

Hi,

 

Is there an option to use the REST API? You can use this both in PowerShell and, for that matter, in Power Automate.

 

If you’re using PowerShell, you can utilize Invoke-RestMethod:
https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/invoke-restmethod?view=powershell-7.4

 

Here’s some documentation on the API:
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report

 

If this is just a one-time task, you can also use the Try It function:
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report