New Column or Field not showing in Power BI Query Editor using Web/API as datasource

[diligenteng]

Hello All,

I have setup datasource using Web/Rest API. I have created few DAX and Conditional columns post initial setup. In the due course, few new fields/columns were added in the REST API call (which is being used as datasource). These new columns/fields are not showing up the Power BI Editor.
a. I have tried refreshing preview and data
b. also, tried editing source query.

Both above methods didn't worked. Please advise on "how to configure the Power BI so that it automatically/dynamically reflect the changes in the columns, whenever any new columns is added or deleted."

[lbendlin]

Show your Power Query code. Most likely you used Table.SelectColumns somewhere.

NOTE:  Power BI becomes very cranky when you keep changing the meta data. It will punish you with extended periods of "Evaluating...".  Try not to do that too much.