Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
For us, this feature is very promising and we have taken steps to implement it within our enterprise (5000+ employees with Pro licenses). However, we ran into the limitation that all Viewers of reports that are developed using this feature must have Build permissions on all underlying datasets, and this is very troubling for us. Giving out Build permissions to employees who only (based on their function, and/or data-literacy level) require to view reports poses a high risk for us.
Currently we are urgently looking for a work-around or alternative solution to offer Customizable managed self-service BI to employees with Power BI within our the enterprise, as advocated in this Microsoft blog. Is there any update on the limitation that Build rights are always needed with the "DirectQuery for Power BI datasets and Azure Analysis Services" feature?