Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Advocate IIHas there been any further thoughts around the end user permissions that are required in order to view a published report that has been crafted from a shared dataset under the Direct Query / Local Model?
Having to add a report end user / consumer to the primary shared dataset with Build permissions is an issue. We have analysts that we restrict to shared datasets and in turn they share out their reports to end users. Having the analyst grant users access to the report they created and then turning to the admins to have the end users granted Build permission to the shared dataset is a security issue. These end users could then connect to the core shared dataset and access data they should not be able to view.
I brought this up a while ago. Is it being addressed? If so when will it be fixed?
hornsjdAdvocate I
I haven't heard that it's been addressed, but I recommend voting on this idea here:
Microsoft Idea · Directquery for datasets only needs read permissions on all datasets (powerbi.com)
- jeroenterheerdt
I can confirm it has not been addressed but will be before we declare this generally available.
AnalystPeteAny idea when it will be declared generally available? I can't see it on the roadmap. We don't allow build permissions so until we can use this with read only access, we can't use it.
