Forum Discussion

aaldo_666's avatar
aaldo_666
Icon for Helper I rankHelper I
3 years ago
Solved

Download PBIX file using service principal

Hi,  I set up service principal and I can use it to list specific report, but Im not able to download that PBIX file. The error I get is Export-PowerBIReport : Operation returned an invalid status ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi aaldo_666 ,

 

Do you use the Reset API or click the download pbix option on the service?

Based on the error message, it appears to be an error caused by insufficient permissions. Please check the restrictions on downloading PBIX files according to the following documents.

Export Power BI embedded analytics reports API - Power BI | Microsoft Learn

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

 

Also, pay attention to report with a sensitivity label can't be exported to a .pdf or a .pptx using a service principal.

 

Best Regards,

Neeko Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

aaldo_666's avatar
aaldo_666
Icon for Helper I rankHelper I
3 years ago

Thank for response. I forgot to put some details. I have Premium per user license and I want to download PBIX file in format of .pbix using powershell Export-PowerBIReport commandlet.
As I read in the link you sent  

  • Exporting a Power BI report to file using the exportToFile API, isn't supported for Premium Per User (PPU).

So I have to wait for premium per capacity license.