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:

becomes

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

Still need help? Contact Us Contact Us