Forum Discussion
SQL Endpoint not updating to semantic models
- 1 year ago
Hi,
Thx for the response.
About an hour ago the table`s appeard. It took nearly a week for the table`s to show up. Adding new tables is now instant, so i am guessing this was a microsoft issue in the backend.
Greetings.
Hi RCrom
Sorry for the late response.
Since the issue persists despite trying the usual troubleshooting steps, here are some advanced debugging steps you can have a try:
- Manually trigger a schema refresh by running:
********************************************************
ALTER TABLE fct_backflush_transactions ADD DUMMY_COLUMN INT;
ALTER TABLE fct_backflush_transactions DROP COLUMN DUMMY_COLUMN;
********************************************************
This forces the system to re-register the table in Fabric. - Manually drop & recreate the table:
********************************************************
DROP TABLE IF EXISTS fct_backflush_transactions;
CREATE TABLE fct_backflush_transactions (...) -- Define schema manually
******************************************************* - If using Import Mode, try switching to DirectQuery and check if the table appears.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
Hi,
Thx for the response.
About an hour ago the table`s appeard. It took nearly a week for the table`s to show up. Adding new tables is now instant, so i am guessing this was a microsoft issue in the backend.
Greetings.