Power BI
Under ReviewDirectquery for datasets only needs read permissions on all datasets
Bus Intel on 26 Mar 2021 02:07:54
The new preview feature DirectQuery for Power BI datasets is very useful
https://powerbi.microsoft.com/en-us/blog/directquery-for-power-bi-datasets-and-azure-analysis-services-preview/
However, its a limitation that the user has to have build permissions on the dataset linked to by direct query. I want to use this feature, but don't want to give the report users build permissions.
I would expect that read permissions would be sufficient.
Administrator on 18 Aug 2021 16:39:32
we are currently looking at this but don't have an exact date yet.
- Comments (14)
RE: Directquery for datasets only needs read permissions on all datasets
Thank You :)https://powerbi.microsoft.com/fr-fr/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/
RE: Directquery for datasets only needs read permissions on all datasets
This is definitely a blocker for empowering self-service users in an enterprise
RE: Directquery for datasets only needs read permissions on all datasets
Also you have to set all build permissions by hand which is a tedious job
RE: Directquery for datasets only needs read permissions on all datasets
Very much needed indeed!!
RE: Directquery for datasets only needs read permissions on all datasets
We're making a "golden" dataset to centrally to share with our markets. The intention is for our market headquarters to be able to share it to different viewers in the market. We cannot do that without giving build permission on the main dataset to the viewers which is not acceptable.
RE: Directquery for datasets only needs read permissions on all datasets
This feature is great but not usable in business case because of this limitation :(
RE: Directquery for datasets only needs read permissions on all datasets
Golden Dataset is a great methodology but unfortunately we cannot use it as we have to give build permission to end users. It will be great if we can limit this to Viewer role only without requiring to have Build permission.
RE: Directquery for datasets only needs read permissions on all datasets
This is indeed very necessary in order to achieve self-service BI on an enterprise level
RE: Directquery for datasets only needs read permissions on all datasets
If not for the presence of other similar bugs, this would be comical.
RE: Directquery for datasets only needs read permissions on all datasets
essentially for it to be used with an enterprise model