e8-Josh's avatar
e8-Josh
Regular Visitor
3 years ago
Status:
Investigating

"Value cannot be null. Parameter name: source" error using Snowflake Connector

I'm getting an error when I'm trying to connect to a Snowflake Database that does not have all caps for the name.  Example: TestDatabaseName vs. TESTDATABASENAME   I am able to connect to Snowflak...
Data Modeling
e8-Josh's avatar
e8-Josh
Regular Visitor
3 years ago

Hello Anonymous,

 

Thanks for taking a look.

Could you elaborate a little on why this is by design now? This causes a hard error in PowerBI for valid Database Names and the ODBC connector that is an option as a workaround does not inherently support the same things, such as DirectQuery, that the Snowflake Connector does. DirectQuery, for instance, being useful for large data sets where importing the data is not very feasible. 

Snowflake Connector Error - Microsoft Fabric Community was not really ever truly solved, and in fact Power Query Snowflake connector - Known Issues indicates this is still being researched and the issue is with hyphenated database names. 

 

My database names do not contain any hyphens. They simply contain lowercase letters instead of being all uppercase.

TESTDATABASENAME - Seems to work

TestDataBaseName - Does not seem to work

Completed Ideas