Forum Discussion

tolgakurt's avatar
tolgakurt
Frequent Visitor
1 year ago
Solved

DirectLake Auto Refresh Error

Hello.   I created a lakehouse on Fabric workspace and took the datasets here to the semantic model and visualized them via PowerBI. I added a new column to the delta format transaction table in La...
capacities
one lake
  • v-prasare's avatar
    v-prasare
    1 year ago

    tolgakurt updating the Semantic Model is the key step after making schema changes in your Fabric Lakehouse. 

     

    always Update the Schema in the Semantic Model After Schema Changes, Any time you rename, add, or remove columns in your Lakehouse table, make sure to refresh and update the dataset schema in Power BI.

     

     

     

    Thanks,

    Prashanth

    MS Fabric community support

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

     

     

v-prasare's avatar
v-prasare
Community Support
1 year ago

tolgakurt updating the Semantic Model is the key step after making schema changes in your Fabric Lakehouse. 

 

always Update the Schema in the Semantic Model After Schema Changes, Any time you rename, add, or remove columns in your Lakehouse table, make sure to refresh and update the dataset schema in Power BI.

 

 

 

Thanks,

Prashanth

MS Fabric community support

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query

 

 

Yacong's avatar
Yacong
Frequent Visitor
11 months ago

hi Prashanth, I had a very similar case related to this post. So appreciate if you can give me some advice.

I'm using pipeline to refresh sematic model, and before that will execute a store procedure which have some drop table and re-create table actions, I guess still the 'cache' is making problem, it occasionally encounter refresh failure, says not found table, but it do exist. I was use 'Wait' to let system auto synchronize schema, but it doestn't solve the problem, please do you have any better ideas?