Power Bi connectivity for Snowflake

Hi,

I have requirement where we are migrating dashboards from Tableau to Power BI. The current tableau dashbord is pointing to Snowflakea and they are using custom SQL queries to connect. Now in Power BI, we are having Snowflake connector which will not support custom queries. 

Workaround for this is to create a ODBC connection using user/system DNS and connect Power BI using ODBC connector. I am getting error like below.

Need assistance in resolving this.

Also, please suggest if this is a feasible option to do so in terms of performance?

I am thinking of creating a view in Snowflake with query which is used in Tableau and connect that view using default Snowflake connector. Is it feasible option?

Please help me on above issues.

Thanks,

Rajesh S Hegde