Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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 😄
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 😄
User | Count |
---|---|
65 | |
27 | |
25 | |
17 | |
11 |