Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Microsoft Power BI Service and Desktop / Reports
Microsoft Windows PowerShell
Executing the PowerShell cmdlet Export-PowerBIReport we receive the below mention error message
Export-PowerBIReport : Operation returned an invalid status code 'Unauthorized'
At E:\Scripts\pbiExportPowerBIReport.ps1:2 char:1
+ Export-PowerBIReport -Id f74199d0-20e3-4946-9764-a80f60a5541c -OutFil ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...rtPowerBIReport:ExportPowerBIReport) [Export-PowerBIReport], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Reports.ExportPowerBIReport
This can be caused for several reasons:
Export-PowerBIReport -Id <Power BI Report ID> -OutFile 'D:\my.pbix2' |
This script is missing the WorkspaceID parameter. If the report does not exist in the My Workspace workspace, then this will return the 'Unauthorized' error message. |
Export-PowerBIReport -Id <Power BI Report ID> -WorkspaceId <Invalid Workspace ID> -OutFile 'D:\my.pbix2' |
If either the Report ID (-id) and/or the Workspace ID (-Workspaceid) is invalid, the 'Unauthorized' error message will be returned. |
Export-PowerBIReport -Id <Power BI Report ID> -WorkspaceId <Power BI Workspace ID> -OutFile 'D:\my.pbix2' |
If you did not upload the PBIX file from Power BI Desktop to the Power BI Service, and there is no PBIX file associated, then the 'Unauthorized' error message will be returned.
|
To resolve this issue, you need to ensure the following:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.