Question about build access

[dapperscavenger]

I have a report in powerBI service, for which I granted build access to 2 other users in the business to go and create their own visuals with.

They have created a new report but are now complaining that their users cannot see the visuals they have created using my dataset.  They get an error "could not retrieve data".   Their report uses directquery and they are saying that all their users also need to have build access to my dataset/report in order to see the visuals.

This seems like an enormous pita for me XD

Questions: is it really necessary to grant all their users build access or is there another way round?  Are there any limits or considerations in having a great many users with build access?  Should I be concerned about load?

[ibarrau · Accepted solution]

Hi. It's true that users reading a report with live connection or direct query to other dataset can't see the visuals unless they have permissions to the source dataset. However, the build it's not necessary. You can just add them to the dataset unchecking all the boxes like "build", "reshare", etc. Just read. That should be enough for the users for reading the new reports created by the developers.

I hope that helps,

[Miguel_Rojo]

Hi @dapperscavenger ,

Just to confirm that I understand completly the idea on this scenario, Is it correct my interpretation?

• Parent report was built using “Direct Query” method.
• Parent report was shared to other users with “Build Access” permissions.
• Users created a new “Child Report” based on the parent and shared it to different stakeholders
• Stakeholders of “Child Report”  cannot see the visuals: They get an error "could not retrieve data".
•  

Question 1: The reason of this error was that the "Parent Report" was built using "Direct Query" method? (in other words, if the "Parent Report" would have been created using "Import" the Stakeholders of "Child Report" wouldn't have had the problems mentioned aboce?

Quesiton 2: ¿Siempre que se construye un "Informe infantil" basado en un "Informe de padres" que fue construido usando "Consulta directa", los usuarios del "Informe infantil" necesitan "Ver acceso" al "Informe de padres"?

I would really appreciate your comments,

Thanks!

[Brunner_BI · Accepted solution]

If you build a report on top of a dataset in another workspace, whoever should view that report needs to have access to that dataset either via "viewer" in the workspace or via direct access to the dataset itself.
Build goes on top of the direct access and is not required.

[ibarrau · Accepted solution]

Hi. It's true that users reading a report with live connection or direct query to other dataset can't see the visuals unless they have permissions to the source dataset. However, the build it's not necessary. You can just add them to the dataset unchecking all the boxes like "build", "reshare", etc. Just read. That should be enough for the users for reading the new reports created by the developers.

I hope that helps,

[Miguel_Rojo]

Hi @ibarrau,

Just to confirm that I understand completly the idea on this scenario, Is it correct my interpretation?

• Parent report was built using “Direct Query” method.
• Parent report was shared to other users with “Build Access” permissions.
• Users created a new “Child Report” based on the parent and shared it to different stakeholders
• Stakeholders of “Child Report”  cannot see the visuals: They get an error "could not retrieve data".
•  

Question 1: The reason of this error was that the "Parent Report" was built using "Direct Query" method? (in other words, if the "Parent Report" would have been created using "Import" the Stakeholders of "Child Report" wouldn't have had the problems mentioned aboce?

Quesiton 2: ¿Siempre que se construye un "Informe infantil" basado en un "Informe de padres" que fue construido usando "Consulta directa", los usuarios del "Informe infantil" necesitan "Ver acceso" al "Informe de padres"?

I would really appreciate your comments,

Thanks!