Forum Discussion
Power Query to CSV column order changes effects references to Power Query
I have what I consider a very bad behavior for references to a Power query when the order of the CSV files the query is based on changes from one refresh to the next, the references to the power quer...
Martin_Weiss Thanks for the suggestion. I should have used better column names in my example to not confuse with the default column names. I do have Promoted Headers in my power query and I see this same behavior.
I also have other Renamed Columns as wells as added columns in my Power Query. I'll have to try to figure out the combination that causes this behavior.
The question is are
Column1, Column3, Column2
part of csv file and what are your settings here
- Sorry for the confusion on the headers. I should have had the same CSV file specify a better row 1 like the following:
Header1, Header2, Header3
Find_This, This_2, This_3
Find_That, That_2, That 3
The first row in the CSV has the headers and is promoted to be the headers for the Power Query.
My option setting is likely the default: Detect column types and headers for unstructured sources according to each file's settings