Manage changing column names in Power BI Desktop

[Anonymous]

Hello, 

I have a csv which containts 35 columns, the problem is that the last 13 columns name will change monthly.

Now when I'm trying to refresh I receive an error like this " name x was not found".

Is it possible to have dynamic changing names in Power BI Desktop?

Thanks

[v-eachen-msft]

Hi @Anonymous ,

When you open a csv file, you can click  edit option to enter query editor.

Then you need to find “Changed Type” in the APPLIED STEPS and delete it.

Then click Close & Apply. This table’s column names can be dynamic when you update your csv files.

Best Regards,

Eads

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.