https://community.fabric.microsoft.com/t5/Report-Server/Error-with-Row-Level-Security-RLS-in-Power-BI-when-using/m-p/3278122#M30079 <P>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.</P><P>&nbsp;</P><P>On my presentation page, I have only one table (Dim_Users) as a visualization, which displays all the users registered in my administration.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>&nbsp;</P><P>However, when I add one table from another dataset via DirectQuery, <U><STRONG>without making any further changes</STRONG></U>, 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.</P><P>&nbsp;</P><P>Any idea why I am encountering this error message and how I can resolve it?<BR /><BR /><BR /></P> Sun, 11 Jun 2023 11:53:51 GMT brief001 2023-06-11T11:53:51Z https://community.fabric.microsoft.com/t5/Report-Server/Error-with-Row-Level-Security-RLS-in-Power-BI-when-using/m-p/3278122#M30079 <P>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.</P><P>&nbsp;</P><P>On my presentation page, I have only one table (Dim_Users) as a visualization, which displays all the users registered in my administration.</P><P>&nbsp;</P><P>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.</P><P>&nbsp;</P><P>&nbsp;</P><P>However, when I add one table from another dataset via DirectQuery, <U><STRONG>without making any further changes</STRONG></U>, 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.</P><P>&nbsp;</P><P>Any idea why I am encountering this error message and how I can resolve it?<BR /><BR /><BR /></P> Sun, 11 Jun 2023 11:53:51 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-with-Row-Level-Security-RLS-in-Power-BI-when-using/m-p/3278122#M30079 brief001 2023-06-11T11:53:51Z https://community.fabric.microsoft.com/t5/Report-Server/Error-with-Row-Level-Security-RLS-in-Power-BI-when-using/m-p/3278624#M30081 <P>Hi there,</P><P>RLS on DirectQuery in PBIRS is not available as far as I know.&nbsp;</P> Mon, 12 Jun 2023 03:48:15 GMT https://community.fabric.microsoft.com/t5/Report-Server/Error-with-Row-Level-Security-RLS-in-Power-BI-when-using/m-p/3278624#M30081 mpsrshl 2023-06-12T03:48:15Z