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 Below is my full list of Power Query Steps that produce the behavior. I tried an enhanced test that added renamed columns and I have not added complexity that reproduces the behavior I'm experiencing with the steps below.
You have 6 Rename Columns steps, what exactly you are doing here?
- The steps that show as renamed columns are actually creating new columns by parsing out data from another column.
Table.RenameColumns(#"DB Type Delimiters",{{"Text Between Delimiters", "Type"}})That's better to have entire sample file. If reproduce steps from your initial post - all woks, no problems.
- My bad for over simplifying what I thought was happening and complaining about something that actually works. I can't post the actual file and I'm working to make my example progressively more complex to determine what step(s) change the behavior to the unwanted behavior.