Forum Discussion
COM error: Microsoft.PowerBi.ReportServer.ASEnginemanagedRoot
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"
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.
1 Reply
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.