Forum Discussion
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?
2 Replies
- AllisonKennedyCommunity Champion
You might find Table.ColumnNames helpful here:
https://docs.microsoft.com/en-us/powerquery-m/table-columnnames
- CBSANew Member
Thanks. Could you please provide a short description how "renaming of columns" would help with extending the model with new columns. I am not sure I can follow.