The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I made some changes to a table in my Lakehouse, adding some columns and dropping some columns.
I am using the table in my custom (new) direct lake semantic model, and I want to refresh the table layout in the semantic model so that the new columns become visible and the dropped columns get removed from the direct lake semantic model.
In this Guy In A Cube video, they say that I need to click the refresh button.
Adding a column to your Lakehouse? Where is it in the Semantic Model??? (youtube.com)
However, I cannot find this button in my custom direct lake semantic model. Has this button been removed? How can I update my table schema (columns) in the semantic model now?
Thanks!
Solved! Go to Solution.
I think I found the answer, I just had to click the Confirm button without doing anything else.
"Selecting the Confirm button with no changes initiates a schema sync. Any table changes in the data source, such as an added or removed column, are applied to the semantic model."
Edit tables for Direct Lake semantic models - Microsoft Fabric | Microsoft Learn
I think I found the answer, I just had to click the Confirm button without doing anything else.
"Selecting the Confirm button with no changes initiates a schema sync. Any table changes in the data source, such as an added or removed column, are applied to the semantic model."
Edit tables for Direct Lake semantic models - Microsoft Fabric | Microsoft Learn
Hi @frithjof_v ,
Thanks for your feedback! Glad to hear you solved the problem yourself!
If you can, please Accept your solution as a "Solution", which will be beneficial for future users to read this post.
Best Regards,
Bof