Forum Discussion

DALI007's avatar
DALI007
Helper II
2 years ago
Solved

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 DataFlowG...
Dataflows
miguel's avatar
miguel
Community Admin
2 years ago

A Dataflow Gen2 doesn't change the schema of a table in the destination at the moment.

 

You can either create a new table by going through the "data destination" configuration for your query and defining a new table, or make the changes in your backend (your LakeHouse) to alter the schema of a table and then update your dataflow gen2 to load the data to the updated schema. In both scenarios you'll have to go into the dataflow gen2 and update the configuration for the data destination.

 

hope this helps!

amolt's avatar
amolt
Resolver I
2 years ago

Hi miguel ,

 

I have a similar problem.
I initially created a schema in a warehouse. I use this warehouse to create a report using PowerBi Desktop. From this point on, I can no longer see the schema changes I make in the warehouse. If I add a column to a dw table, I can't see it in the PowerBI model.
Is this normal?
How can I update the PowerBi semantic model schema when I make changes to the source structure?
What's more, even when I delete the table from the semantic model, and add it again, I get back exactly the same structure as before, without the new column...

  • DALI007's avatar
    DALI007
    Helper II
    2 years ago

    Hello amolt,
    it worked, thanks for your help.
    Thank you

  • miguel's avatar
    miguel
    Community Admin
    2 years ago

    I'd recommend posting your full scenario in the Power BI forum:

    Power BI forums - Microsoft Fabric Community

    It doesn't seem to be related to a Dataflow Gen2, so it might be best for someone from the Data Warehouse team or the Power BI to take a look at it

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi DALI007 
    We haven’t heard from you on the last response and was just checking back to see if your query has been resolved. Otherwise, will respond back with the more details and we will try to help.
    Thanks

  • DALI007's avatar
    DALI007
    Helper II
    2 years ago

    Hello Anonymous,
    Not yet, actually my problem as it is indicated in the tittre of subject how to do a refresh of semantic model after an update of dataflow Gen2. To my knowledge, with the default settings, a Direct Lake dataset is automatically refreshed when the data is loaded into a Lakehouse. But in my case I have the dataflowGen2 which is updated every day (it is a parametrage that I set up) but the dataset (semantic model) is not updated.
    Thank you in advance for your help.
    Thanks