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

sheetalshettiga ,

that could be the reason,

there have been many changes in the past.
You can check if there is duplicate M-code in the DataModel as well, it would probably be under tables - partitions:

 

#"Parsed JSON" = Json.Document(Source),
model = #"Parsed JSON"[model],
tables = model[tables],
tables1 = tables{0},
partitions = tables1[partitions],
partitions1 = partitions{0},
source = partitions1[source]

 

Unfortuantely I'm not aware of any other alternative currently. It looks as if programmatically creating pbix is a thing of the past with the new medatadata format.

 

 

sheetalshettiga's avatar
sheetalshettiga
Helper IV
5 years ago

ImkeF  There is no duplicate M code in the partition in DataModelSchema file