Forum Discussion

mike_honey's avatar
mike_honey
Memorable 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
Microsoft 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 :)

cdknuth's avatar
cdknuth
Frequent Visitor
8 years ago

Hi arify,

 

How would I accomplish this:

 

I'd like to rename my columns either on import or immediately following.

 

Example name that comes in: [DIM A].[YEAR].[YEAR].[MEMBER_CAPTION]

 

Name I want to display: Year