User Profile
daaa
Advocate I
Joined 4 years ago
User Widgets
Contributions
Re: Test as role "not supported" message for composite model *new*
Anonymous RLS can perfectly be set up on the imported tables in the composite model, which is why "show as role" very much should be working. Please reopen this case since its simply not true that it has been resolved. Honestly, it rather upsets me that the old thread was ignored by you and your peers for several months, even though it got a lot of attention, and now you are closing this one down without even fully understanding the issue. Is this really the kind of support we get after investing a lot of money into PowerBI?Test as role "not supported" message for composite model *new*
This is a copy of: https://community.fabric.microsoft.com/t5/Issues/Test-as-role-quot-not-supported-quot-message-for-composite-model/idc-p/3965157#M107651 I have created this new one, because the old one seems to be completely ignored, even though it has got a lot of attention. _________________________________________________________________________ I have report which uses a composite data model, with a mix between DirectQuery to other Power BI datasets and some imported tables from SQL Server. The model also uses calculation groups, allthough I do not think this is related to the issue. The data model also has RLS, and I can test this in desktop and it works as intended. However, when I publish the report to the service and I want to "test as role", I get the following error message. Is this a bug, or is "test as role" really not supported for a composite model?Re: Test as role "not supported" message for composite model
Hi Anonymous , In fact RLS works fine, I just cannot test it online. Some more details on my setup. I create a relationship between the imported tables and the tables coming from Power BI over directQuery (DQ) I implement RLS on the imported table, having the relationship to the DQ table. I put a column from the imported table that has a relation to the DQ table as a report level filter, and set it to "is not blank". If I do the above RLS works fine, and I can test it in Power BI Desktop. I just cannot test it online, which I still think is a bug, but apparently the community support have stopped monitoring this thread. But even though I cannot test it online, I have verified with an end-user, that RLS still works fine when the report is published.Access to Power BI datasets in composite model
I have a composite model consisting of multiple Power BI datasets with a directquery connection, and some imported data from a SQL database. The gateway setup looks as follows: Everywhere it says "Optional - Add to gateway" is the directquery connections to Power BI datasets. Question: When I share the report from this composite model, the users cannot see anything, unless I share every single Power BI dataset that is used in the directquery connection, which is quite a chore. Is there any workaround for this? I tried adding a gateway connection for all these optional ones, but could not get it to work.Re: Test as role "not supported" message for composite model
Hi Anonymous , SSO is not enabled. As mentioned my model is a composite model with DQ from a Power BI dataset and import from SQL server. I have implemented RLS, and I can test it in Power BI Desktop, where it works as intended. I just cant test it online, because I get the error shown. If I read your message correctly, you are saying RLS shouldnt work at all with my datamodel setup? If yes, that doesnt seem to be the case - at least not in Power BI DesktopTest as role "not supported" message for composite model
I have report which uses a composite data model, with a mix between DirectQuery to other Power BI datasets and some imported tables from SQL Server. The model also uses calculation groups, allthough I do not think this is related to the issue. The data model also has RLS, and I can test this in desktop and it works as intended. However, when I publish the report to the service and I want to "test as role", I get the following error message. Is this a bug, or is "test as role" really not supported for a composite model?
