Forum Discussion

CBSA's avatar
CBSA
New Member
4 years ago

Update data model when csv file gets extended by extra columns

Dear fellows,

 

I have a data model in Power BI desktop that was loaded from a couple of csv and Excel files. The .csv files were exports from a database. Afer I started modeling the relationships between the tables, establishing a DAX calendar and a few measures, we received some updated versions of the .csv files which are now extended by a few extra columns.

 

I used Python to bring the columns into the original order and tried "update from data sources". After bringing the columns into the original order, the import now runs without issues. But the problem is that the new columns are not recognized and they do not show up in the tables. What can I do?