Forum Discussion

diligenteng's avatar
diligenteng
Regular Visitor
2 years ago

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

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

Need Help
Tips and Tricks

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.