Forum Discussion
Unable to run report from Report Builder without admin group membership on report server
Hi dmarchant,
I'm more surprised that they can connect at all using a shared dataset. As far as I know, this isn't supported.
Power BI report data sources in Power BI Report Server - Power BI | Microsoft LearnEven here it indicates no support:
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Super UserHi 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.
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).
- tayloramy
Hi dmarchant,
I'm more surprised that they can connect at all using a shared dataset. As far as I know, this isn't supported.
Power BI report data sources in Power BI Report Server - Power BI | Microsoft LearnEven here it indicates no support:
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.