shared data sources
1 Topic
Unable to run report from Report Builder without admin group membership on report server
We have a user who has content manager access to the folder with our shared data sources in our Power BI Report Server. This user can run reports using those data sources from the report server site itself. When the user tries to build a report from Report Builder, he can connect to the shared data source and even refresh the fields in his local dataset. But, when he tries to run the report in Report Builder, he gets an authentication error. The user has read permissions in the database used by the shared data source. It seems like there's some problem with Report Builder on his machine making use of the shared data source on the report server. If we add the user to the Admins group on the actual report server (in Computer Management), the problem goes away. Why can the user not run a report from his machine that uses a shared data source without being in an admin group? Thank you in advance!Solved1.3KViews0likes7Comments