Forum Discussion

mike_honey's avatar
mike_honey
Icon for Memorable Member rankMemorable Member
10 years ago

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...
Tips and Tricks
arify's avatar
arify
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Meanwhile the author of "Table.TransformColumnNames" (hint: me) is crying somewhere :'( I think it came out in July '15 update.

 

Nice code anyway :)

edwardrmiles's avatar
edwardrmiles
Icon for Helper III rankHelper III
9 years ago

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 "?