"Value cannot be null. Parameter name: source" error using Snowflake Connector
EXPECTED:
Snowflake Database names with lowercase letters work. Be able to get data from those databases without issue.
ACTUAL:
Snowflake Database names with lowercase letters do not seem to work. Causes "Value cannot be null. Parameter name: source" error.
REPRODUCTION STEPS:
1. Create a Snowflake Database with a lowercase in name: TestDatabase vs. TESTDATABASE
2. Open PowerBI
3. Transform Data
4. New Source
5. Select Snowflake
6. Fill in Server and Warehouse (and Role if needed)
7. Sign in to Snowflake Server with credentials
8. Expand database created
-- Error happens here as seen in screenshot above. Clicking error makes the error popup happen to copy details/report issue.
CURRENT WORKAROUND:
You can use the ODBC Connector after setting up an ODBC connection. However, the ODBC Connector does not support everything the Snowflake Connector supports (Conditional Columns for example) so things need to be reworked.