Power Query Missing Columns

Hi All,

I use the API to pull our data into Excel for automated reporting, and it does the job quite nicely :slight_smile:

However, I’ve added a new column to collect a bit more information, but that column doesn’t seem to be available to select when choosing columns within the query.

It’s a number field (although I have tried changing it to a text field, and a formula field in case it was the field type that was the issue).

Any thoughts?

Were you able to find a solution to this problem?