topic Re: COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot in Report Server

COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot

brysonb12 — Tue, 22 Nov 2022 13:47:39 GMT

Good Morning, getting an error when trying to load my dashboard to the Report Server. I try to load my Power Bi dashb oard to the Report Server.

The dashboard data is conncected through Snowflake. When I try to load the dashboard to the server this is the error meassage I am getting

"COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot. The given data sourse kind is not supported. Data source kind:UnknownFunction.

Please try later or contact support. If you contact support, please provide these details"

Re: COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot

d_gosbell — Tue, 22 Nov 2022 21:41:37 GMT

As per the documentation here Power BI report data sources in Power BI Report Server - Power BI | Microsoft Learn Snowflake is not supported for Scheduled Refresh or Direct Query on Report Server. It only supports "Cached Data" - which means that you can refresh the report in Power BI Desktop (if the model is in import mode) then upload the report to the Report Server.

Since Snowflake is a cloud based service your best option is to put reports using this as a data source onto a workspace in the Power BI cloud service.