
I am trying to pass a measure from the On Power BI Button Clicked action, which seems to work, I am then trying to Export to File for Paginated Reports and use that value in the Parameters Value section, and it always fails here... I have even just tried to manually set this value ignoring the value from Power Bi and still fails... I am getting a code 401, nothing I try seems to work!! Any help would be appreciated.
Hi , @Simon_Hill
According to your error code , the action return Http 401 , which means "Unauthorized".
And you need to check if you meet the prerequisites for this action:
For more information, you can refer to :
Export paginated reports with Power Automate - Power BI | Microsoft Learn
And this action is also the REST API in Power BI Side.You can also try it first in Power BI side :
Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Yueyun Zhang