Molecule adds new columns to our API from time to time. (We do not remove or alter columns, generally, to avoid creating compatibility issues.)
When columns are added, PowerQuery and/or PowerBI sometimes create an error message because Microsoft's tools expect a fixed set of columns, in order. There are two ways to avoid this error:
Option 1
Remove the Columns=xx parameter from the generated PowerQuery/PowerBI Code. Before and after shown below.
Option 2
When connecting Molecule's APIs to PowerQuery/PowerBI, use the JSON format option (/valuations?as_of=xxxx-xx-xx) instead of CSV (/valuations.csv?as_of=xxxx-xx-xx).
