Solved: COM error: Microsoft.PowerBi.ReportServer.ASEngine...

brysonb12 · ‎11-22-2022

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"

d_gosbell · ‎11-22-2022

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.

View solution in original post

d_gosbell · ‎11-22-2022

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.