Forum Discussion

sheetalshettiga's avatar
sheetalshettiga
Helper IV
5 years ago
Solved

Issue on loading data from Power Query on generating pbix file by automation

Hi all,   I am trying to create a .pbix file by automation that is when u unzip a .pbit we get a DataModelSchema and DataMashup file I am feeding in the content to these file from a json metadata a...
Need Help
Show and Tell
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi sheetalshettiga ,

    I've studied your problem description. 

    Reason is probably that there are no column metadata for the new columns.

    You could either try to fill them in by hand in the DataModelSchema file or instead create a dummy column for the new column (ideally with the correct format already) and load that with blank values.
    This would ensure that the new columns are included in the datamodel and can then just be filled with the correct values afterwards.

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi sheetalshettiga ,

I've studied your problem description. 

Reason is probably that there are no column metadata for the new columns.

You could either try to fill them in by hand in the DataModelSchema file or instead create a dummy column for the new column (ideally with the correct format already) and load that with blank values.
This would ensure that the new columns are included in the datamodel and can then just be filled with the correct values afterwards.

sheetalshettiga's avatar
sheetalshettiga
Helper IV
5 years ago

ImkeF  will zipping back to .pbix file or apply changes  on powerbi not do the work for me?Do I need to manually fill the new columns in DataModelSchema file?