Forum Discussion
Build Access - Direct Query report
Hi Miguel_Rojo
-1- Yes, you should be able to assign Build permissions to the model in the same way. However, based on the nature of Direct Query connections (all visual queries are sent directly to the source), be mindful that anything your new 'Builder' creates will increase load on the source so ensure they know/understand this to avoid undue load on your source.
-2- No, reports they create won't necessarily be visible to their audience by default. They will still need to share their creations appropriately. No, their audience will not need access to your parent report to view the child report, but they will inherently be given a level of model access that allows them to view the child report content.
-3- Yes, many limitations, from restricted M and DAX functions to potentially excessive source load. Have a read through the following for a good overview:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Pete
Hi Miguel_Rojo
-1- Yes, you should be able to assign Build permissions to the model in the same way. However, based on the nature of Direct Query connections (all visual queries are sent directly to the source), be mindful that anything your new 'Builder' creates will increase load on the source so ensure they know/understand this to avoid undue load on your source.
-2- No, reports they create won't necessarily be visible to their audience by default. They will still need to share their creations appropriately. No, their audience will not need access to your parent report to view the child report, but they will inherently be given a level of model access that allows them to view the child report content.
-3- Yes, many limitations, from restricted M and DAX functions to potentially excessive source load. Have a read through the following for a good overview:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about
Pete
