Forum Discussion

AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

Paginated Report Error in the Service: data source was found but the credentials were incorrect

I'm having trouble when publishing a .rdl file to the service. It works fine in the Power BI Report Builder desktop app but displays this error when I try to open it in the online workspace (after a ...
Need Help
AlexisOlson's avatar
AlexisOlson
Super User
5 years ago

I finally figured out at least part of the "why" question myself after trying a bunch of different things.

 

It turns out it was indeed a permissions issue. The gateway account had read permissions but not permission to execute a stored procedure on the SQL server. I discovered this by swapping out the stored procedure with an equivalent text query in the Report Builder. This eliminated the problem for me.

 

Adding execute permission on the database for the gateway account did not resolve the issue. I will update if I ever figure out how to get it to work with a stored procedure instead of a text query. This part of the question remains unresolved.

Luka's avatar
Luka
Regular Visitor
3 years ago

To me it helped when I turned off check mark for : "Report viewers can only access this data source with their own Power BI identities"

 

Location of this setting: Workspace -> Report -> More options (3 dots) -> Manage -> Data source credentials -> edit credentials

 

Maybe helps someone.