Excel PowerQuery/PowerBI & New Columns

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


How did we do?