Forum Discussion
Problem with semantic model refresh after data transformation in Data Flow Gen2
Hello,
I have created a DataFlow Gen2 in Microsoft Fabric. I made some transformations by adding a new column "type_site", as shown in the screenshot "image1". However, when I publish my DataFlowGen2 and try to refresh the data in my lakehouse (LakeHouse.png) , the changes are not being reflected. Note that I did not receive any error message. Can you please help me resolve this issue?
Thank you in advance for your assistance.
Hello DALI007 ,
check out this post, maybe it'll help :
Re: How can I update the PowerBi semantic model sc... - Microsoft Fabric Community
13 Replies
Hey!
I am not sure I completely follow. How was the table in your destination (LakeHouse) created? Are you able to check the schema to see what data types it requires and that is bound to?
is the dataflow inserting the right values according to the definition of the schema of the lakehouse table that you see in the lakehouse experience and table browser?Hello Miguel,
I inserted the first time a table (a schema ) which does not contain the last column "type_site". But after a transformation I wanted to insert a new table that will replace the existing table with the addition of this new column "type_site". I do not know if this action is possible to do it automatically by just updating the semantic model or I must manually delete the old table and insert the new table again. I hope I was clear in my explanations.
Thank you in advance for your returnHey!
Im not sure I follow. You mention a semantic model, a Lakehouse and a DataflowGen2.
The Dataflow Gen2 cannot load data directly to a semantic model. However, it can load data to a Lakehouse.
If you initially created a table in your Lakehouse to load data to, how did you create such table? Did you use the Dataflow Gen2 to create it? Assuming that such table needs to change its schema, how do you plan to change its schema? Or are you trying to create a completely new table? If you try to create a new table, how will you create such table?
