cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TDM
Frequent Visitor

RLS using a DataFlow in DirectQuery mode

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:

Couldn't load the data for this visual

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!

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @TDM,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
TDM
Frequent Visitor

OK, so long story:

  • the model in PBI Desktop is a mixed storage one, SQL data source is import and PBI DataFlow is DirectQuery
  • user table comes from the DataFlow which is in DirectQuery
  • RLS works in PBI Desktop
  • RLS errors out in the service
  • after digging a bit together with folks from Microsoft support we noticed that this is not related to RLS but to the interaction between DQ and Import
  • even with no RLS the service was complaining about no gateway being available despite there being no refresh triggered or needed
  • once a gateway was referenced (again, there's no need for one since I am not triggering the SQL data source refresh in the service) everything seems to be working

I'm still testing this though.

 

The error messages are highly cryptic 🙂

 

Thank you! 

v-shex-msft
Community Support
Community Support

Hi @TDM,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!