Forum Discussion

brief001's avatar
brief001
Icon for Helper II rankHelper II
3 years ago

Error with Row-Level Security (RLS) in Power BI when using DirectQuery with Multiple Data Sources

I have a question about Power BI. I have imported a table (dataflow) into Power BI. On this table (Dim_Users), I am using Row-Level Security (RLS) through a filter function on a column that contains email addresses. I filter this column using the userprincipalname() function.

 

On my presentation page, I have only one table (Dim_Users) as a visualization, which displays all the users registered in my administration.

 

When I publish this and test the security as a role, it works as intended. The visualization only shows the row from Dim_Users that corresponds to the role I am testing.

 

 

However, when I add one table from another dataset via DirectQuery, without making any further changes, I immediately receive an error message when testing the RLS security on the only visualization (Dim_Users) shown in the report. The error code I receive is HTTP status code 401.

 

Any idea why I am encountering this error message and how I can resolve it?


1 Reply

  • Hi there,

    RLS on DirectQuery in PBIRS is not available as far as I know.