Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Build Permissions Required on any dataset connected via Direct Query to Analysis Service?
This is a documented requirement. However, it has unintended ramifications. For example, when I connect to my HR dataset, I can publish only metrics that are not sensitive on my local dashboard. However, due to the requirement to have Build permissions directly on the HR dataset I have now exposed the full HR data model (via Power BI Desktop or Excel) to any user of my dashboard. This seems like an overshare and a security risk.
- jeroenterheerdt
thanks for the feedback - we are aware of this and are investigating how to change this.
dhannaaHelper IV
I hope this will be fixed in near future. I just started to use these new features and now it feels a little frustrating to realize all the end-users would need build rights to use the newly created reports.
- jeroenterheerdt
this will be fixed.
hornsjdAdvocate I
It is unfortunate, I feel like in it's current state it's unusable for Power BI Premium subscribers (with the potential re-use, it seems like enterprise deployments would benefit the most).
I would recommend voting for this feature on uservoice: Microsoft Idea · Directquery for datasets only needs read permissions on all datasets (powerbi.com)
- jeroenterheerdt
thanks for the feedback - we are currently investigating this
