[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource

[Katebrk]

Hello! 

I have the following situation:

I've uploaded my report to Report Server. The data source that I use in report - is Azure SQL Database. Now I am trying to schedule refresh, but the following error occurs: 

SessionID: 6307fae2-ab63-4942-abaa-daa028e***
[0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource ***.database.windows.net;datawarehouse is not found..
[1] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, Datasource ***.database.windows.net;datawarehouse is not found..

I have Report Server January 2021 and Power BI optimized for Report Server. When I refresh data from Power BI optimized for RS, it works fine. When I test the connection in "Data sources" tab, it works fine too: 

Could please anybody tell me what the problem could be? 

Thank you! 

[Anonymous]

Hi, I have the same problem with my report. After the update to May 2021 Report server, we have the problem with the scheduled refresh (issue unknown callsite).

[gsprague · Accepted solution]

Hi Kate, we have fixes for various Datasource Not Found issues in the Report Server May 2021 release. Are you able to upgrade to see if this fixes your problem?

[Katebrk]

Hi! We've upgraded Report Server to May 2021 and were able to schedule refresh. 

Thanks!

[gsprague]

If you cannot upgrade to May for whatever reason, there is a mitigation that could help:
Solved: Fix for "Datasource XXXXXX Not Found" PowerBI Refr... - Microsoft Power BI Community

[seba]

Any mitigations for the following error  - [0] -1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, The given data source kind is not supported. Data source kind: UnknownCallsite..

https://community.powerbi.com/t5/Report-Server/Power-BI-Server-Jan-2021-Scheduled-Job-Fails-The-give...

[gsprague]

Hi, UnknownCallsite is an error message indicating dynamic datasources. Those are not supported for refresh. Here are some docs for further information:

Power BI report data sources in Power BI Report Server - Power BI | Microsoft Docs

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs