Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
SauravRajJoshi
Frequent Visitor

Event stream source(Azure SQL CDC) cannot take tables with underscore(_) in the name.

I have an eventstream connected to Azure SQL with CDC enabled. I want to connect few tables with underscore(_) character in them. How can this be achieved? All other tables have been connected and is working fine, what would be a workaround for tables with these names?

1 ACCEPTED SOLUTION

Hi @SauravRajJoshi ,

Thank you for reaching out. I’ve tested adding an underscore in the table names, and it appears to be possible.

Wenyang_0-1725270839490.png

 

To better understand and assist with your issue, could you please provide more details? Specifically:

  1. Error Messages: Are you encountering any specific error messages when trying to connect the tables with underscores? If so, could you share the exact error message?

  2. Data Flow: Is the issue that data is not being ingested from the tables with underscores, or is it that the connection fails altogether?

  3. CDC Enabled: Could you also check if the Change Data Capture (CDC) is enabled for these specific tables with underscores in their names?

These details will help us identify the root cause and suggest an appropriate solution.

Looking forward to your response.

 

Best regards,
Wenyang

 

 

 

View solution in original post

6 REPLIES 6
Anonymous
Not applicable

Hi @SauravRajJoshi ,

 

Could you try adding square brackets? Table names containing special characters may not be recognized directly. When you select multiple tables, are the table names separated by commas? Example: [dbo].[table_1], [dbo].[table_2]

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Hi @Anonymous 


No it doesn't work that way either, please refer to the screenshot below. I have tried using braces, square brackets and others, and tried with the tables of my azure sql database. Still doesn't work, could there be anything else to try? or is there a release plan for this?

SauravRajJoshi_0-1724668408340.png

 

 

Regards

Saurav

Anonymous
Not applicable

Hi @SauravRajJoshi ,

 

As of now, Microsoft has not officially planned for this feature. 

You can submit an idea for it at Home (microsoft.com) and wait for users with the same needs as you to vote for you to help make it happen as soon as possible. 

You can check out the plans for Real-Time Intelligence here. What's new and planned for Real-Time Intelligence in Microsoft Fabric - Microsoft Fabric | Microsoft...

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Thanks @Anonymous 

 

Will conside this as a limitation for now, thank you for assistance.

 

 

Regards

Saurav

Hi @SauravRajJoshi ,

Thank you for reaching out. I’ve tested adding an underscore in the table names, and it appears to be possible.

Wenyang_0-1725270839490.png

 

To better understand and assist with your issue, could you please provide more details? Specifically:

  1. Error Messages: Are you encountering any specific error messages when trying to connect the tables with underscores? If so, could you share the exact error message?

  2. Data Flow: Is the issue that data is not being ingested from the tables with underscores, or is it that the connection fails altogether?

  3. CDC Enabled: Could you also check if the Change Data Capture (CDC) is enabled for these specific tables with underscores in their names?

These details will help us identify the root cause and suggest an appropriate solution.

Looking forward to your response.

 

Best regards,
Wenyang

 

 

 

Hi @Wenyang 

 

So the issue was when creating the connection, what you're showing is after creating the connection, going to edit mode and adding tables. Yes this solution works for now, it's more like a loophole than a solution I think. I don't know if they will update it, hopefully they wont.

Thank you

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors