Is there a way the to filter the power query table rows based on the RLS filter?

[ppatel91]

What I am trying to achieve here is to when user log in on our embedded reports that filter should apply to my power query table row to narrow down only one row for that perticular USER_GUID so I can use that row later to call my Azure Model. In the screen shot you can see that I have USER_GUID column and I want to filter that based on the USER who logs In which already applies to my reports using RLS but I want it to reflect on my power query as well. If user 'a' logs in then my reports will filter accordingly because of RLS but I want my power query to display only one row with USER_GUID= 'a'

Is there any other way to achieve this?

#powerquery #powerBI 

[ppatel91]

Hello Edhans,

Thanks for the Answer! Yes, I am using Direct Query. How would that work with DQ can you explain a bit more?

[edhans · Accepted solution]

Row-Level Security on a DirectQuery to Power BI dataset composite model: My Findings - RADACAD has a good overview of how to implement it if you are using DQ to the the database. It wouldn't work for DQ to another Power BI dataset (composite model). Just clarifying as DQ now has multiple meanings and is getting confusing.

[edhans]

Not unless you are using Direct Query. Once an import model has been refreshed, Power Query is out of the picture, and PQ doesn't look at any DAX info (RLS Roles) when refreshing. It is a one way street.

But if using DQ, then that info is passed back to the server which has to handle the request and could be filtered, but performance will suffer vs an import model in the vast majority of cases.