Forum Discussion
Auto-rename all Query columns e.g. to remove underscore
Today I was grappling with shaping a series of Queries based on a SQL Datawarehouse. They use what's probably the best column naming standard (IMO) e.g. Sales_Amount. However PBI Desktop doesnt see...
thanks arify - at least that function is exposed now. I found your last example in the thread above much more useful than the one posted in the documentation. That scenario (special characters in column headings) seems very unlikely.
Anyway I had to loop back to this to do something similar - inserting spaces for "Camel Case" column names e.g. CustomerName. So I have built a couple of examples using Table.TransformColumnNames and added it to my list of demo files (link below) for future reference - it's the one named:
Power Query demo - Renaming Columns automatically
mike_honey I just downloaded it and tried it out, it's pretty cool! I want to look around at that folder some time :)