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
Hi mp390988
It looks like you’re using DirectQuery to a semantic model rather than a simple live connection. If it were a live connection, the first visual would have shown an error as well. Using more than one semantic model in a report, or adding any additional data source, forces the connection to switch to DirectQuery. DirectQuery to another semantic model requires viewers to authenticate and doesn’t use the author’s credentials. My usual workaround is to create a blank report page using that semantic model and give users view access to it.
Hi danextian ,
I am trying to follow your workaround where you said create a blank report page using that semantic model (Profit) and give users view access to it. I tried doing that and tested it at the user's machine and they get the following error. Do I need to give them view access to the semantic model or just the report? The idea is that I don't want them to have any access to the semantic model Profit.
Thanks