Status:
Investigating
PowerAutomate Export to File for Power BI Report Wont Work with RLS Direct Query into PowerBIDataset
I am trying to use the 'Export to File for Power BI Report' in Power Automate and getting the error 'Couldn't load the data for this Visual' Errors for visuals that contain data from a live DQ connec...
Hi AlexNachreiner ,
In your case, it seems that the RLS settings in the underlying semantic model might be causing the issue. When RLS is applied, Power BI sends authenticated Azure AD credentials in the queries to the underlying data source. This enables Power BI to respect the security settings that are configured at the data source level3.
If you remove the RLS from the underlying model, the Power Automate workflow succeeds without error because it no longer has to deal with the additional security layer imposed by RLS.
As a workaround, you might consider adjusting the RLS settings or the configuration of the connection.
Best regards.
Community Support Team_Caitlyn