Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I am now getting the above error since updating PowerBI Desktop and it won't load a visual which seemed to work fine before.
I have one active relationship joining the table and 2 inactive relationships joining elsewhere in the table so I can use Userrelationship to easier calculate using DAX.
Context: I've joined a staff table joined to an operation table where it's possible the staff member will have one of a possible 3 roles within a row of data. i.e Staff 1, Staff 2, Staff 3.
Any suggestions / ideas?
Thanks
Solved! Go to Solution.
Hi @v-shex-msft
Thanks for the suggestions.
I selected more than one filter in more than one table for the RLS which seemed to clash.
I fixed it by just creating a dynamic table and using one filter for the RLS.
I had the same issue. The problem was in bi-directed connection for one pair of tables in the model (Both instead of Single). After fixing the problem has been resolved.
Hi @Anonymous,
Since I can’t reproduce your issue, can you provide a sample to reproduce your issue?
In addition, you can try below methods to ensure which part the issue appeared:
1. Check if the issue is related to visual.
Try to use old table to create a new visual and check if the issue appeared again.
2. Check if the issue is related to Row-Level Security.
Try to delete the old Row-level security, then build a new one to test if the issue appeared.
3. Check if the issue is related to the relationship.
Remove the relationships and re-create the relationship and test again.
If above is not help, please share some detail information about your issue.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
Thanks for the suggestions.
I selected more than one filter in more than one table for the RLS which seemed to clash.
I fixed it by just creating a dynamic table and using one filter for the RLS.
Can you expound on how you solved it? I am having the same issue right now
facing the same issue. can you share how you solved this?
Do you currently have any RLS to your fact table?
The way I solved the problem is that I had changed by RLS from the Fact table to My Dynamic table instead i.e. Office table which links to all of my fact tables.
Do you currently have any RLS to your fact table?
The way I solved the problem is that I had changed by RLS from the Fact table to My Dynamic table instead i.e. Office table which links to all of my fact tables.
Can you add more context to your solution?
Hi MG83, could you give me some details about your solution using a dynamic table ?
Tnx,
Mario
Hi MG83, could you give me some details about your dynamic table to solve the problem ??
To add to this I think it may be since I've applied row-level security??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |