Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
We are connecting to Snowflake using built-in Snowflake connector with PowerBI Desktop 2019, version March 2022.
When we add Snwoflake as a new source using the built-in connector, connection is established successfuly. If databases with case sensitive names exist, PowerBI is not able to access these databases. It returns "ODBC: Error 42000 SQL compilation error...".
The same issue appears in existing reports.
However, the code generated by PowerBI is valid.
let
Source = Snowflake.Databases("mysnowflakeaccount.snowflakecomputing.com","""103_WH_Stage_MY_WH"""),
#"103_Stage_MY_DB_Database" = Source{[Name="103_Stage_MY_DB",Kind="Database"]}[Data],
MY_SCHEMA_Schema = #"103_Stage_MY_DB_Database"{[Name="MY_SCHEMA",Kind="Schema"]}[Data],
MY_TABLE_Table = MY_SCHEMA_Schema{[Name="MY_TABLE",Kind="Table"]}[Data]
in
MY_TABLE_Table
This issue first occures with PowerBI March 2022 (version 2.103.661.0). Older versions do not seem to have this problem (February 2022 and December 2021 were tested).
Workarounds successfully tested:
We could not find a final solution for the internal Snowflake connector. Are there any ideas, please?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @jmorgenstern
Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.
The link of Power BI Support: https://powerbi.microsoft.com/en-us/support/
For how to create a support ticket, please refer to https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...
Best Regards
Community Support Team _ Ailsa Tao