Scheduled refreshes have been failing after upgrading to PBIRS January 2021.
 -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, No credentials were found for the datasource.
 -1055129594: The current operation was cancelled because another operation in the transaction failed.
The problem exists in our development environment and the credentials do exist and they work. The refresh works on the same report in our UAT environment. Both are have been upgraded to January 2021 (1.107698.27886). We caught it after the UAT upgraded. We do not want to upgrade production until this is resolved. Please let us know if there is a solution or workaround.
I created a simple report with just one dataset that returns one row. The schedule refresh fails with that error. Is there any solution for this? the system is an upgrade of PBIRS. The schedule refreshes were working with the earlier Jan2021 release (1.10.7698.27886 (Build 15.0.1105.195). This is basic functionality of Powerbi should be fixed asap.
i already posted multiple questions about this, I have the same problem!
We updated to the last version you mentioned above, but we have the exact same error on scheduled refresh.
Reports are all import report (that's why we need a scheduled refresh...) credentials are entered and correct. We have it in our productionenvironment, HELP. Exact same report does not give the problem in our testing environment....
Which datasource did you use? The RS version desktop does not allow a composite model. This limited functionality means that all the tables must be exclusively the same type either import query mode or directly query mode.
Also you should try update to the newest version for both Report server and desktop for RS(launched on Feb 5 2021).
Newest Report Server updated this month with fixes of some bugs.
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Scheduled refreshes fail for all of the existing reports on this development server. I focused on one of the failing reports which has 2 queries from the same data source. I created a new report and used one of the queries from the failing report. I uploaded it, set up the data source and then a scheduled refresh. The scheduled refresh succeeded. I then added the second query to this report and made the report identical to the one that was failing. I uploaded it and ran a successful scheduled refresh. So we have 2 identical reports: One that existed before the upgrade where scheduled refreshes failed and another identical report that I just created where the scheduled refreshes are successful.
Scheduled refreshes work on our UAT server and it is running the January 2021 version. We compared PBIRS, SQL Server, and Windows server settings and they are identical.
We have no idea what can be causing this problem. Is this being looked into by Microsoft?
The data source is a query based on tables on one SQL Server database. The scheduled refresh does work for this same report in our UAT environment. Also, in our testing I created a simple report that pulls 10 rows from one SQL Server table and it still fails.
Paul, we have just upgraded to 1.10.7737.32652 in the development. The problem still exists.
The data source is just one SQL Server database. The credential are fine. Scheduled refreshes work on the exact same report and data source in the acceptance environment (1.10.7698.27886). We compared the 2 environments and could not find notable differences (yet). Any help in resolving this would be most appreciated.
Click here to learn more about the August 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.