Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
cphite
Helper I
Helper I

can connect to OData source in desktop but not on SSRS/PBI site

I have a report that uses several data sets that have been published to our on-prem SSRS/Power BI site.  I can connect to these via ODATA connections in the Power BI Desktop app and they work just fine.  I can deploy the report to the site, and it works; the problem is when I try to create a scheduled refesh job it fails with the error below.  I have the ODATA sources using a Windows account that definitely has access to navigate to the datasets on SSRS, and I have the firewall disabled just in case it was an issue.

 

All of the data sets are running queries against a local SQL Server instance on the same server.

 

When the error comes up, it's almost always a different dataset that is named; I assume this is just a result of timing, but mention it just in case it's relevant.  

 

[0] -1055784932: The credentials provided for the OData source are invalid. (Source at http://myServerName/Reports/api/v2.0/datasets(path='/Power%20BI%20Reports/Sales/manufacturer')/data.). The exception was raised by the IDbCommand interface.
[1] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[3] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[4] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.
[5] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

1 ACCEPTED SOLUTION

Power BI Report Server...

 

I figured it out...  I had to set the credentials on the report itself, not just the data sources - on the report they were set to Anonymous.  First time deploying this way 😄

 

 

View solution in original post

2 REPLIES 2
lbendlin
Super User
Super User

Is this Power BI Report Server or Power BI Service?

Power BI Report Server...

 

I figured it out...  I had to set the credentials on the report itself, not just the data sources - on the report they were set to Anonymous.  First time deploying this way 😄

 

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.