topic Re: Update endpoint - Database in SQL database

Update endpoint - Database

Tom_CA — Mon, 25 Nov 2024 00:14:01 GMT

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?

Re: Update endpoint - Database

Anonymous — Mon, 25 Nov 2024 04:50:48 GMT

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.

Re: Update endpoint - Database

Tom_CA — Mon, 25 Nov 2024 05:07:02 GMT

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?

Re: Update endpoint - Database

dlevy — Mon, 25 Nov 2024 05:37:09 GMT

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?

Re: Update endpoint - Database

Anonymous — Tue, 26 Nov 2024 06:14:14 GMT

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 - Microsoft Fabric | Microsoft Learn

Best Regards,

Jayleny

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

Re: Update endpoint - Database

Tom_CA — Tue, 26 Nov 2024 21:13:04 GMT

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!

Re: Update endpoint - Database

sukkaur — Wed, 04 Dec 2024 16:55:34 GMT

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