Forum Discussion

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
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

Community Champion

5 years ago

Hi sheetalshettiga ,

have you tried any approaches of it meanwhile?
I might have not been clear enough, but one way to do this without any additional hacking in the code would be to create the future columns already in the query editor and just leave them blank or fill with dummy values. But make sure to give them the desired format/types already.

This will trigger them appearing in the datamodel schema file and you can then just replace the M-code like before.