Power Automate Emailed Power BI Report Error

[kp_wood13]

I've had a report sent via email utilizing Power Automate for some time. I just recently switched to a shared semantic model and updated the report, now it is still generating a PDF but the report throws an error. I ran into the same error with general access to the reports through our Power BI app and resolved that by adding RLS and security directly to the shared semantic model. I'm using credentials in Power Automate that have those same rights already, I have also tried adding distinct RLS to this flow and still getting this error. I am able to load the report in the Service and the App without an issue using the same credentials. Any suggestions?

[v-nmadadi-msft]

Hi @kp_wood13 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution or if some other troubleshooting step worked please let us know and accept it as a solution so as to help other community members
Thank you

[v-nmadadi-msft]

Hi @kp_wood13 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you

[v-nmadadi-msft · Accepted solution]

Hi @kp_wood13,
Thanks for reaching out to the Microsoft fabric community forum.
This issue is most likely cause by the user not having the required permissions for the dataset and the report, as you have mentioned you are using the same credentials for Service and it is working there, I can only suggest to re check the credentials in power automate and then
Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious. 

Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

If you find this post helpful, please mark it as an "Accept as Solution" and give a KUDOS.
Thanks and Regards

[GilbertQ]

Hi @kp_wood13 

As far as I know, this could be related to the row level security. Another option might be to use the export report API in order to pass through different user credentials in order to satisfy the row level security requirement. Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn