Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

vijaykvs — Thu, 16 May 2024 20:59:35 GMT

I am trying to export pbix report to my local machine. I have admin access on the workspace and am able to list the reports. However, I'm getting "unauthorized..." error while trying to export the report. Appreciate any help here.

Here is the code I'm using

Connect-PowerBIServiceAccount Export-PowerBIReport -Id XXXXX -WorkspaceId XXXXX -OutFile .\ExportReportByPowershell.pbix -Verbose

Error Message:

Export-PowerBIReport : Operation returned an invalid status code 'Unauthorized'
At line:12 char:3
+ Export-PowerBIReport -Id $reportId -WorkspaceId $workspace.Id -OutF ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : WriteError: (Microsoft.Power...rtPowerBIReport:ExportPowerBIReport) [Export-PowerBIReport], HttpOperationException
+ FullyQualifiedErrorId : Operation returned an invalid status code 'Unauthorized',Microsoft.PowerBI.Commands.Reports.ExportPowerBIReport

VERBOSE: Request Uri: https://api.powerbi.com/v1.0/myorg/groups/xxxxx/reports/xxxxx/Export
VERBOSE: Status Code: Unauthorized (401)

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

lbendlin — Fri, 17 May 2024 01:02:20 GMT

There's a long list of restrictions when it comes to PBIX download. Validate that your scenario is not covered by that list.

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

vijaykvs — Fri, 17 May 2024 16:40:06 GMT

Can you please share those requirements with me. I didn't see much in the documentation. Thanks!

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

lbendlin — Fri, 17 May 2024 18:25:08 GMT

Download a report from the Power BI service to Power BI Desktop - Power BI | Microsoft Learn

Limitations when downloading a report .pbix file

You can download a file while in either Reading view or Editing view. You must be at least a Contributor to the workspace that the report is in. If the report is based on a semantic model in another workspace, you need to be at least a Contributor to that workspace as well.
If you create a report by using the Create button in the Power BI service, and it's based on a semantic model in another workspace, you can't download it.
Reports created in Power BI Desktop must be published or uploaded to the Power BI service before you can download them.
If you create a report in the Power BI service, you have to save it before you can download it.
You can't download reports based on semantic models that are imported from OneDrive for work or school.
You can't download reports based on local Excel or CSV files that were uploaded to Power BI.
The report you're downloading must be published or updated after November 23, 2016. Reports published earlier aren't downloadable.
You can't download the eight original built-in sample .pbix files from the Power BI service. However, you can download those same .pbix files from the Power BI samples article.
You can only download usage metric reports in live connected report mode.
You can't download a copy of a report if the copy is saved in a workspace other than where the original report is saved.
If you download a live connection report (connected to SSAS or AAS) after you change its data source by using REST APIs Update Datasources or Update Datasources In Group, the downloaded .pbix will still contain the old data source.
Reports created in the Power BI service that are based on a single semantic model that's configured for large models or incremental refresh, or that has been modified by using the XMLA endpoint can only be downloaded in live connected report mode.
If you create a Power BI report based on a semantic model in one workspace and publish the report to a different workspace, you can download the report in live connected report mode only, if the semantic model is configured for large models or incremental refresh, or it has been modified by using the XMLA endpoint.
Downloading a .pbix file after deployment isn't supported as part of the deployment pipeline (ALM).
Downloading a .pbix file that's larger than 1 GB is only supported when the .pbix is in live connected report mode.
You can't download reports that are created in the Power BI service and based on a semantic model in My Workspace in live connected report mode.
If you disable the switch in the tenant settings described in Control the use of semantic models across workspaces, your users can't download a .pbix file from copied reports or reports created from datasets in the same workspace.
Limitations when downloading a semantic model .pbix file
- To download the .pbix file, you must be at least a Contributor to the workspace.
- Semantic models with incremental refresh can't be downloaded to a .pbix file.
- Semantic models enabled for large models can't be downloaded to a .pbix file.
- Semantic models migrated from Azure Analysis Services by using the Azure Analysis Services to Power BI Premium migration feature can't be downloaded to a .pbix file.
- Downloading a .pbix file after deployment isn't supported as part of the deployment pipeline (ALM).
- Semantic models modified by using the XMLA endpoint can't be downloaded to a .pbix file.
- You can't download semantic models based on data imported from OneDrive for work or school.
- Downloading a .pbix file that's larger than 1 GB isn't supported.
- Semantic models with automatic aggregations enabled can't be downloaded to a .pbix file. You must disable automatic aggregations training in the semantic model settings and delete the aggregations tables by selecting the checkbox Delete automatic aggregations tables.

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

vijaykvs — Fri, 17 May 2024 20:32:27 GMT

That worked, thank you. Going by the error, I was wondering if there was a limitation with accessing the report. I see that the Large Semantic Model was set on the report. I am able to export after turning that off.

topic Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport in Developer

Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport

Limitations when downloading a report .pbix file

Limitations when downloading a semantic model .pbix file

Re: Unauthorized error when trying to export report using Powershell command Export-PowerBIReport