Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
diligenteng
Regular Visitor

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

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors