Forum Discussion
Error fetching data for this visual
Hi mp390988
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank danextian , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
Yes, users must have at least Read (Viewer) access to the Profit semantic model, or the visuals that trigger queries will fail.I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Best Regards,
Community Support Team
The most likely cause is a composite model scenario.
Even though the report connects to the Profit semantic model, only some of the tables you used are actually imported locally into the new model. The first visual works because it relies only on these local/imported tables, so it does not query the Profit dataset.
However, the second visual uses a measure that still references a remote table in the Profit semantic model. When users without permission try to view that visual, Power BI attempts to query Profit directly and fails hence the connection error.
So the issue isn’t the measure itself but that some visuals still depend on remote (DirectQuery) objects from Profit which require users to have access to that underlying model.
Both visuals are built from using fields from a calculated table.
The measures also refer to the calculated tables.
Permission will still be required if the calculated table are referencing a semantic model through direct query. I tried a calculated table approach as a workaround to import data from a semantic model in a different workspace the users had no access to. It worked one time but then the permision issue kicked in.
