Forum Discussion

brysonb12's avatar
brysonb12
Frequent Visitor
3 years ago
Solved

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 Snowflak...
COM Error:
  • d_gosbell's avatar
    d_gosbell
    3 years ago

    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.

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
3 years ago

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.