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...
Meanwhile the author of "Table.TransformColumnNames" (hint: me) is crying somewhere :'( I think it came out in July '15 update.
Nice code anyway :)
I'm struggling to understand from the documentation how Table.TransformColumnNames works. Any chance you could provide a simple example, e.g. prefixing every column of a table called DimDate with the string "Order "?