Column names not updating for the data getting through ODBC connection

[Anonymous]

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.

[AngelinaHansen]

Open the Transform Data Window > Advanced Editor > Change the api version to 14 the previous version [ApiVersion = 14].   

[Anonymous]

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

[edhans]

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.