Showing results for 
Search instead for 
Did you mean: 

Composite Models not working with RLS and custom data



I have 1 Direct Query, 3 Import tables, and when I am trying to add custom data for example


Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTSUYopNTAwTjY2UIrViVYyggtYQgSM4QKGFhARE4QeM1OwiClQBMjWVoqNBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Value = _t, Metric = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Value", Int64.Type}, {"Metric", type text}})
#"Changed Type"


And published the report to service, and tried accessing with one of user who is assigned in my role. 

My report dispalys just the blank pages, like this...

With RLS.png



Actual Report should be dispalyed like this.

With Out RLS.png

This is just one tab, but the visuals in all the tabs are behaving the same way. 


This report works perfectly fine, when create a table in my database for these custom codes and load it as a table. 



Status: New

Hi @yash1105,


As there are 1 Direct Query, 3 Import tables and 1 custom data table in your report, which table column do you use to define the RLS role? 


How do you share the report with another user, by adding the user as a member of the app workspace or via Share button? 


In Power BI service, please test as the role on your side to see if the same issue occurs. Also please ensure the user are running the same browser to view report as you. 


Best Regards,
Qiuyun Yu 



Role is created on the table with Direct query.

My Direct query has just 3 columns

Email, Order#, Client#


We are not using apps, and no users have access to workspace.

We share just the report and add the person to role or a AD group. 


After a test user raised the concern, the screen shot provided in my query above is from "Test as the role" 


Hi @yash1105,


I'm not able to reproduce the issue. Please update your Power BI desktop to the latest version 2.64.5285.741 then republish report to test again. If issue persists, I would suggest you create a support ticket to get dedicated support. 


Support Ticket.gif


Best Regards,
Qiuyun Yu 


I have the same problem, but only when such report is published to a premium workspace.

When I publish the report to My Workspace then it works as it should (when testing "as role" and selecting different users with differnet roles, the report filtrs the data as it should).

Only when published to a premium workspace then it shows all tiles related to filtering by RLS as blank, that was tested by real users (with whom I shared the report) and also by "test as role". And my desktop application is the latest version 2.64.5285.741 (64bit)