Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I am using MongoDB ODBC connection as a data source. columns names in my MongoDB collection will be changing frequently. but the Power Bi shows the same column names that are load initially even the all the column names are changed.
Open the Transform Data Window > Advanced Editor > Change the api version to 14 the previous version [ApiVersion = 14].
HI @Anonymous,
In fact, this is a common issue causing by the cache mechanism of power query.
AFAIK, power query will cache previous data structure into query steps, it will return an error for 'column filed keys not matched' if new records did not match with cached structure. You need to check 'change type' and other query steps to fix the column name which updated.
In addition, you can also add a custom step with 'RenameColumns' function to replace the source table name with a default name list, it will prevent small changes on table structure. (column name changes)
RenameColumns = Table.RenameColumns(Source,List.Zip({Table.ColumnNames(Source),{"OrderDate","Region","Rep","Item","Units","UnitCost","Total"}})),
BTW, you can take a look at the following link to know more bout this:
Datasource column name changed
Regards,
Xiaoxin Sheng
If you are talking about Power Query in Power BI, did you do a REFRESH ALL to the screen? Power Query caches data to make development faster, but changes on the server may not be reflected, including changes in numbers.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI Reporting