Forum Discussion

dmarchant's avatar
dmarchant
Frequent Visitor
11 months ago
Solved

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 ...
report builder
Shared Data Sources
tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
11 months ago

Hi dmarchant, 

 

When the new report is published to the report server, is the user going into the manage reports section, data sources, and then explicitly selecting the shared data source to use? By default it will be blank I think, so the shared data source needs to be selected after the report is uploaded. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

dmarchant's avatar
dmarchant
Frequent Visitor
11 months ago

Thank you for your reply. The issue is happening when the user is running the report from Report Builder on his machine. The report behaves normally when run on the report server site itself.

  • tayloramy's avatar
    tayloramy
    Icon for Super User rankSuper User
    11 months ago

    Hi dmarchant, 

     

    Gotcha, that makes sense then. WHen running locally, it won't use the saved data source on the report server, so the user would need to enter credentials. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution. 

    • dmarchant's avatar
      dmarchant
      Frequent Visitor
      11 months ago

      Right, and the user is using his windows credentials. He is part of a group that has read access to the database used by the data source. He can even go out to that database directly and query it without issue. He just can't seem to use the shared data source when the report runs (though like I said, he can initially connect to the data source fine and even refresh the fields in the report's dataset).