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.
