Composite Models not working with RLS and custom data

Status: New
by yash1105 Member on ‎11-15-2018 09:38 AM

Hi,

 

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

 

let
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}})
in
#"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. 

 

 

Comments
by Moderator v-qiuyu-msft
on ‎11-15-2018 10:44 PM

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 

by yash1105 Member
on ‎11-17-2018 05:08 PM

@v-qiuyu-msft

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" 

by Moderator v-qiuyu-msft
‎11-22-2018 01:34 AM - edited ‎11-22-2018 01:39 AM

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 

by jgabalm Occasional Visitor
on ‎11-28-2018 07:45 AM

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)

 

Matus

Idea Statuses