Update endpoint - Database

[Tom_CA]

Hey everyone, I created a new table in my Fabric database, but the new table didn't appear in my endpoint or semantic layer. Anyone has the same problem?

[dlevy]

Hi @Tom_CA - What do you see when you open the replication monitor in SQL database by clicking the replication menu at the top and selecting Monitor Replication? 

[Anonymous · Accepted solution]

Hi @Tom_CA 

I have created a table named Warehouse in the Fabric database.

When you are in the endpoint interface, you just need to click the refresh button to make your newly created table appear.

Result:

Best Regards,

Jayleny

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

[Tom_CA]

Hey @Anonymous Thank you for your reply!

I tried, but it didn't work for me. When I create a table using a script, it works fine. Could you try to create using a dataflow Gen2?

[Anonymous]

Hi @Tom_CA 

I used Dataflow Gen 2 to create it, and it displayed correctly. You can refer to the steps in the following documentation to check if there are any issues with your creation process.

SQL database tutorial - Ingest sample data and create objects and data using T-SQL and pipelines - M...

Best Regards,

Jayleny

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

[Tom_CA]

Hey @Anonymous  thank you for your test. Let me try again because I did the same step, and it didn't work as expected.

If it works, I will mark it as a solution.

Thank you!

[sukkaur]

Tom_CA,

    Currently if you create a table with a column that is not supported in Mirroring - it will not replicate the whole table. Here is a document with all the details - Limitations of Mirroring for SQL database (preview) - Microsoft Fabric | Microsoft Learn

Please review your table columns types. 

Best Regards