New report based on multiple semantic models of existing reports - Visualizations problems

[hugo_p_23]

Hi everyone,

I created a new report based on multiple semantic models of existing reports, all these reports have RLS.

When sharing this new report online, people are not able to see some visuals.

I tried to give Builder accesses to the old semantic models, I created identical accesses at the RLS level in the new report (I used 2 dimension tables to connect to all the semantic models, one for calendar and one for Cost Centers).

I can't understand why it doesn't work.

We are talking about 4 different semantic models, and about 50 different tables.

Thanks in advance.

Hugo

[v-nmadadi-msft]

Hi @hugo_p_23 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the community members for the issue worked. If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Thanks ands regards

[v-nmadadi-msft]

Hi @hugo_p_23 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution so other members can easily find it.
Thanks and Regards

[v-nmadadi-msft]

Hi @hugo_p_23  ,
Thanks for reaching out to the Microsoft fabric community forum.

If RLS produces unexpected results, check for the following issues:

• Incorrect relationships exist between model tables, in terms of column mappings and filter directions. Keep in mind that RLS filters only propagate through active relationships.
• The Apply security filter in both directions relationship property isn't correctly set. For more information, see Bi-directional relationship guidance.
• Tables contain no data.
• Incorrect values are loaded into tables.
• The user is mapped to multiple roles.
• The model includes aggregation tables, and RLS rules don't consistently filter aggregations and details. For more information, see Use aggregations in Power BI Desktop (RLS for aggregations).

When a specific user can't see any data, it could be because their UPN isn't stored or it's entered incorrectly. It can happen abruptly because their user account has changed as the result of a name change.

Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to give "Kudos"

Thanks and Regards

[v-nmadadi-msft]

Hi @hugo_p_23 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[GilbertQ · Accepted solution]

Hi @hugo_p_23 

Currently there are some restrictions around using multiple semantic models in a single report or what is known as composite models. As to why at some points the Row Level security will not work and this is by design. Use composite models in Power BI Desktop - Power BI | Microsoft Learn