Power Automate Flow does not Extract Data from Power BI visual

[Dinosauris]

Hello,

I included in my Power BI Report a button which extracts data from the power BI reprot, with my guest account and admin account the data gets extracted as expected. However, for the users with the normal account it does not work. They can run the flow, but it fails where I want to set the field I extract to a variable. It looks tike the Power BI date is not getting extracted.

The Power BI report is in a Fabric workspace and it uses Direct Lake Connection to the lakehouses. Originaly the data is coming from dataverse. I've tried to add the users even as administrator on all the workspaces and on the Power Automate Flow I assigned them a system administrator role. However, nothing worked. Can you please help me out here? 

BR, Iris

[Dinosauris · Accepted solution]

I was able to fix the error, the following happened:

The user accessed the Power BI in German language, however, I was accessing and designing the Power Automate Flow in English language. While the information which is generated by the Power BI flow such as username and timestamp is automatically translated in the language which the users use the fields extracted from Power BI where not. Meaning that I needed to change the naming of the Power BI fields to the German language. Very annoying bug which should get fixed by Microsoft. 🙂

Here is the screenshot which shows that the entities where extracted in German language, thus when calling them in English language it did not work:

Thus I needed to change it from "Max of" to "Maximum von" as shown in the picture below:

[Anonymous]

Hi @Dinosauris ,

1. Ensure that the users with normal accounts have appropriate permissions on the Power BI report. They should have at least read access to the data sources used in the report.  Confirm that the users with normal accounts have sufficient permissions to run the Power Automate flow.
2. Review the Power Automate flow to ensure error handling is in place. The error message you provided ("BadRequest. The variable 'Approved_Version' of type 'Integer' cannot be null or empty value.") suggests that there might be an issue with how the variable 'Approved_Version' is being set or accessed. Make sure that the variable is initialized properly and that there are no scenarios where it could end up being null.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group