Forum Discussion
Issue on loading data from Power Query on generating pbix file by automation
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.
Hi sheetalshettiga ,
which Desktop version are you using?
With newly created files in the current PBI Desktop version, your approach is not possible any more. You will always get error-messages about file corruption. This is because the metadata format for pbix files has been changed recently.
If you use an old file with the current version, you might even have duplicate M-code: 1 in the Mashup and for the loaded tables there might event be M-code in the DataModelSchema File.
So you would have to make the changes in the 2 areas then.
But this is all totally unsupported and I would not wonder, if that would fail as well.
ImkeF I am using july version itself since DataModelShema and DataMashup files are available there when we unzip a .pbit. Is this the loading issue so Mquery steps are not being applied on DataModelSchema file?Any other way of handling it?
