- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
Composite Models not working with RLS and custom data
Status: NewHi,
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...
Actual Report should be dispalyed like this.
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.
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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"
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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.
Best Regards,
Qiuyun Yu
- Mark as Read
- Mark as New
- Bookmark
- Permalink
- Email to a Friend
- Report Inappropriate Content
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