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...
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
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