Cannot connect to a Snowflake database that has a hyphen in its name
Steps to reproduce:
- Create a Database and table in Snowflake
- Have the database name include a hyphen. Ex: TEST-DB
CREATE DATABASE "TEST-DB";
CREATE TABLE PUBLIC.TEST_TABLE (
ID INT,
DESCRIPTION STRING
);
INSERT INTO PUBLIC.TEST_TABLE values (1, 'test');
- Create a new report in Power BI Desktop and set up a connection to this Snowflake database with the Snowflake connector in Power BI: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-snowflake
- Choose DirectQuery
- Select Fields to create test report
- Save report and publish to a workspace
- Observe the "syntax error line 1 at position 8 unexpected '-'." error encountered when loading the report in https://app.powerbi.com/
3 Comments
Hi , pdenoyelles
I've searched the forums and found no restrictions related to database names with hyphen. Maybe, you can create a database without hyphen in the database name, and then connect to the Service. I also found some connection documentation for you, you can refer to it.
https://docs.microsoft.com/en-us/power-query/connectors/snowflake
https://docs.microsoft.com/en-us/power-bi/connect-data/service-connect-snowflake
https://docs.snowflake.com/en/user-guide/oauth-powerbi.html#troubleshooting
Best Regards,
Community Support Team _ Ailsa TaoHi Anonymous ,
We do have other databases without hyphens where the connection works but some of our use cases have databases with hyphens. The issue is that this functionality was confirmed to be working on our end a month ago or so but now no longer seems to be functioning.
Is there a plase where we can log bugs directly to support, or is this "Issues" page the place for that?
Thanks!
Hi pdenoyelles
You mentioned that “this functionality was confirmed to be working on our end a month ago” , then I suggest you can open a support ticket .
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/683031
Best Regards,
Community Support Team _ Ailsa Tao
