Cannot connect to a Snowflake database that has a hyphen in its name

[pdenoyelles]

Steps to reproduce:

1. 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
  • Navigate to the dataset
  • 
  • Navigate to Settings
  • 
  • Set the credentials to the published dataset in https://app.powerbi.com/
  • 
  • Go back to the workspace and navigate to the report
  • 
• Observe the "syntax error line 1 at position 8 unexpected '-'." error encountered when loading the report in https://app.powerbi.com/

• 

[v-yetao1-msft]

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 Tao

[pdenoyelles]

Hi @v-yetao1-msft ,

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!

[v-yetao1-msft]

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/6830...

Best Regards,
Community Support Team _ Ailsa Tao