Forum Discussion
Couldn't load the data for this visual. Composite Model
I am facing issue when I am testing RLS for a composite model in Power BI service. I am getting following error -
Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Http Status Code: 401
Activity ID: 913caa3a-6d7f-4800-ae38-9b0ad0abdacf
Correlation ID: c8970c85-461c-71f1-ccea-e7f149da8d7f
Request ID: d2b2bfc1-6a22-9aaa-137d-aac7034c1479
Time: Thu Jul 15 2021 02:02:26 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.16399.43
Client version: 2107.1.06860-train
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net/
Scenario -
I have 2 workspaces - WS1 and WS2
I have 2 reports - RPT1 in WS1 and RPT2 in WS2
RPT1 is build on composite model, with DQ to Power BI Dataset to RPT2 and Tables from SQL Server in storage mode. There is RLS defined on RPT1, but no RLS on RPT2. No when I test RLS on RPT1 from Power BI desktop it works fine, but when I test same RLS using a userid on Service the visuals throw above mentioned error. Visuals works fine in service if only RLS is tested without user. I have tested the RLS even after the removing DQ and adding those tables directly in RPT1 as torage mode and it works fine.
2 Replies
- v-angzheng-msft
Community Support
Hi, gauravtomer
Is there a viewer role assigned to users in the workspace?
Row level security works on the viewer rolerefer:
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Yes I have assigned user viewer role in workspace. I even tried with admin, but same issue. I am tried my userid also and I am the owner of workspace, but no change.
