Export-PowerBIReport returns Unauthorized

[aabundez]

I am the admin for a Workspace (original workspace paradigm, not new one) and I cannot run the Export-PowerBIReport cmdlet. It keeps returning Unauthorized. I also have the Power BI Administrator role and am the owner of this particular O365 group. I am also a Global Administrator in O365.

I can run all the other Get cmdlets for the entire Organization. It's just Export-PowerBIReport which is giving me problems. I've assigned all the rights I know about. Let me know if there's anything else I can do to troubleshoot the issue.

[aabundez]

Quick update. I was able to use Invoke-PowerBIRestMethod and the Export Reports In Groups endpoint just fine. So it's not a permissions issue.

Invoke-PowerBIRestMethod -Url 'groups/{groupId}/reports/{reportKey}/export' -Method Get -OutFile "C:/filename.pbix"

[CodeCyclone]

Can you add the -Verbose flag to Export-PowerBIReport and execute Resolve-PowerBIError -Last and paste the result here?
The code is invoking the Power BI SDK, there might be a bug there.

[sqlchick]

I can add that I'm seeing this as well -- but only with a V1 workspace. Each of my V2 workspaces behave as expected. When executing Export-PowerBIReport on a V1 workspace, it returns unauthorized even though I'm an admin on the workspace itself & can export the PBIX from the portal without any issues. So I agree this seems like a bug. I get the same result using a client tool (like PowerShell ISE or VSCode) & the same using Cloud Shell in the Azure portal.

[robertplata]

Is there an update as to whether the export-powerbireport cmdlet has a bug? I am receiving the same unauthorized error. I was unable to use Invoke-PowerBIRestMethod. Thanks

[sagarkul]

Export-PowerBIReport -Scope Organization -Id $sourceReportId -OutFile "$filePath"
Above line works with service principal

[ManuelWernerbtelligent]

In my case this works only if i add the workspace guid in the cmdlet.

Export-PowerBIReport -WorkspaceId {GUID} -Id {ID} -OutFile C:\Users\Downloads<Filename>.pbix

Second solution is to move to the Invoke-PowerBIRestMethod and the Export Reports In Groups like @aabundez mentioned.

Best

Manuel