Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have RLS enabled and he users table comes from a DataFlow in DirectQuery. RLS is working fine in desktop.
In the service however no visuals are displayed with the following error:
An error was encountered during the evaluation of the row level security expression defined on table 'T'. Error message: {"error":{"code":"DMTS_MonikerWithUnboundDataSources","pbi.error":{"code":"DMTS_MonikerWithUnboundDataSources","details":[{"code":"Server","detail":{"type":1,"value":"DB"}},{"code":"Database","detail":{"type":1,"value":"db_name"}},{"code":"ConnectionType","detail":{"type":0,"value":"Sql"}}],"exceptionCulprit":1}}}
where T is the import mode table that is filtered by RLS, DB is the server where the db_name data source that is in import mode resides.
Thank you!
Hi @Anonymous,
What type of data source are you worked on? If you mean AS data source, I think you may need some UPN settings on power bi service side:
Manage your data source - Analysis Services - Power BI | Microsoft Docs
Regards,
Xiaoxin Sheng
OK, so long story:
I'm still testing this though.
The error messages are highly cryptic 🙂
Thank you!
Hi @Anonymous,
According to your description, this issue sounds more relate to reports that include different mode data sources. (AFAIK, DAX expression has different usage limits when you work on different connection modes) Perhaps you can directly contact to power bi support team for further support.
In addition, thanks for your sharing, I think they will help with other users who faced similar scenarios.🙂
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |