Forum Discussion
Users with view access on workspace can't view data in report
they do have build permission. What they were missing is ReadAll on the warehouse, same as for a lakehouse in this one:
seems like a pain to have to grant a user viewer and then go into the warehouse settings and add another separate permission.
Helper IHi jbaz does user have Build permission on the semantic model ?
With DirectQuery to a semantic model, Viewer alone is often not enough for stable access. Contributor works because it implicitly grants Build.
they do have build permission. What they were missing is ReadAll on the warehouse, same as for a lakehouse in this one:
seems like a pain to have to grant a user viewer and then go into the warehouse settings and add another separate permission.
- luisoliveira89
Yes, indeed, since you are working with Direct Query users must have access to the source as well.
Great that you've found a solution.
Best regards,
Luis Oliveira