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 connection from another PowerBI semantic model that contains Row Level Security.
The below picture shows the error for the DQ connection into a Semantic Model, in which the underlying semantic model has RLS while the Dataset using 'Enter Data' is being populated.
If I were to remove the Row Level Security from the underlying model the Power Automate workflow succeeds without error. I am an Admin in the Premium Workspace where both Datasets live and additionally have added myself to the RLS group.
Comments
-
v-xiaoyan-msft
on:
Lakehouse table error : Encountered Azure error wh...
-
v-xiaoyan-msft
on:
Connect Partitioned table in Fabric Lakehouse to P...
-
v-xiaoyan-msft
on:
Issue: unable to load word cloud
- tolsond on: Power Bi Mark as Date Table issue after November 2...
-
v-pbandela-msft
on:
Can't refesh Data in PBI
-
v-xiaoyan-msft
on:
Access to ADO ODATA Feed from PowerBI is fails fro...
-
v-xiaoyan-msft
on:
Unable to export data from visuals that contain vi...
-
v-xiaoyan-msft
on:
Select All Slicer Option Sucks
-
v-xiaoyan-msft
on:
Absence of Create icon in parameter section
-
v-xiaoyan-msft
on:
how do i disable download for a specific PBI works...
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