Dynamic RLS

Question

Dear all,&nbsp;I am tyring to establish Dynamic RLS, but when trying to verify my attempt at app.powerbi.com I get following message:What does it mean? Both types, report and semantic model, are there...&nbsp;&nbsp;Can please anybody help me and tell me, what I need to do? I am lost...

anonymous · Answer

Hi&nbsp;Orstenpowers&nbsp;,
&nbsp;
Here are a few steps to troubleshoot and resolve this issue:
1.Verify Workspace Location: Ensure that both the report you're trying to test and the semantic model are saved in the same Power BI workspace. This is a fundamental requirement for the "Test as role" feature.
2.Check Report Connection: Make sure that the report you've created is indeed using the semantic model you've applied the Dynamic RLS to.
3.Test in Power BI Desktop: Before attempting to test in the Power BI service, use the "View As" feature in Power BI Desktop to verify that your RLS setup works as expected.&nbsp;
&nbsp;
Best Regards,
Neeko Tang
If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.&nbsp;

orstenpowers · Answer

Dear Neeko,&nbsp;Thank you very much for your help!Reg. workspace location; as you can see from the below screenshot, both report and semantic model are saved in "my workspace"Reg. Test in PBI Desktop: This also worked fine.Reg. Report Connection: Where can I check whether or not the report is using the semantic model??? I have no idea...&nbsp;Looking forward to hearing from you I remain&nbsp;Best regardsOrstenPowers

anonymous · Answer

Hi&nbsp;Orstenpowers&nbsp;,
&nbsp;
Based on your error message, you could try connecting the original semantic model using Power BI Desktop then simply creating a new report and applying RLS, then publishing to the same workspace and testing again.

&nbsp;
Best Regards,
Neeko Tang
If this post &nbsp;helps, then please consider Accept it as the solution&nbsp; to help the other members find it more quickly.&nbsp;

orstenpowers · Answer

Dear Anonymous&nbsp;Neeko, Thanks for your proposal! However, without doing any changes, I could test the role for Dynamic RLS successfully this morning, which is great and I also can see that the Dynmic RLS concept works fine...&nbsp;However, when looking into it more precisely, I recognized that a number of visuals was not displayed as expected.For the concerned visuals, I got following message:&nbsp;"Die Daten für diese Visualisierung wurden nicht gefunden.Es wird erwartet, dass Verknüpfungspfade eine Struktur bilden, aber die Tabelle "SALES_DATA" umfasst zwei Verknüpfungspfade zur Tabelle "AD_Germany": "'SALES_DATA'-&gt;'Sales Header'-&gt;'AD_Germany'" und "'SALES_DATA'-&gt;'ST_PRODUCT_GROUP'-&gt;'Budget_Sales_GER_nach_AT'-&gt;'AD_Germany'"&nbsp;From the message above I understand that I need to get rid of one of these relation paths, but after several successless tries, I hope that this community can help me!?When looking into my relations, it looks as follows.&nbsp;SALES_DATA(Order No)&nbsp; &nbsp;--&gt;&nbsp; &nbsp;Sales Header(Order No)Sales Header(Sales Rep (Order))&nbsp; &nbsp;&lt;--&gt;&nbsp; &nbsp;AD_Germany(Sales Rep(Order))&nbsp;SALES_DATA(Sales Statistics Group)&nbsp; &nbsp;&lt;--&nbsp; &nbsp;ST_PRODUCT_GROUP(Sales Statistics Group)ST_PRODUCT_GROUP(PG_TOTAL)&nbsp; &nbsp;&lt;--&gt;&nbsp; &nbsp;Budget_Sales-GER(PG_TOTAL)Budget_Sales_GER(Sales Rep(Order))&nbsp; &nbsp;&lt;--&nbsp; &nbsp;AD_Germany(Sales Rep(Order))&nbsp;What do I need to do in order to get the model started correctly? Looking forward to your proposals I remain

orstenpowers · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;do you (or anybody else) have any idea what I need to change with the existing relations so that the model will work properly?&nbsp;I was so happy that the dynamic RLS works and now I am stopped by these unexpected problems...😞

Forum Discussion

Dynamic RLS - Role cannot be tested

5 Replies

Related content

Unit testing in report

Dynamic Filter

Dynamic Subscription

Testing Dynamic RLS?