COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot

[brysonb12]

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 · Accepted solution]

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.