Forum Discussion

NiteshS's avatar
NiteshS
Icon for Helper I rankHelper I
3 years ago
Solved

Few columns are missing from Lakehouse tables when fetched via Dataflow Gen2

Dear Community,   I imported tables from Dataverse using Dataflow Gen2 in my Lakehouse tables. In the power query editor screen, all the columns were visible. But when the table was published, few ...
dataflow
  • SidJay's avatar
    SidJay
    3 years ago

    Hi Nitesh,

     

    Could you please also confirm that you have re-edited the mapping (in case you added columns after the initial mapping)? We do not yet have a mode where the mapping is automatically updated everytime you add a column. You have to explictly edit the Output Destinations settings.

     

    Thanks

miguel's avatar
miguel
Icon for Community Admin rankCommunity Admin
3 years ago

Could you confirm if these columns are available in the Lakehouse and the issue is simply visualizing them on Dataflows Gen2? or is the issue that the columns do not exist in the lakehouse despite you defining those columns to be created by your original dataflow gen2 with the lakehouse as the output destination?

NiteshS's avatar
NiteshS
Icon for Helper I rankHelper I
3 years ago

Thank you for the response. This numeric column were not getting published when the destination was not selected before publishing. Now after selecting the destination, I am able to see the numeric columns.