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...
I've gotta be honest, Power Query is not too discoverable on its own, arify. This is not a criticism of you, but the UI guys. The latest iteration of the DAX editor in PBI is pretty decent. The Power Query editor is pretty dismal. There's no intellisense or anything similar to help identify which functions are available. It's clunky to cross back and forth from PQ to the formula reference online and back.
You're right, I wish it had something like Intellisense too, but I'm not sure if it'll happen anytime soon. Instead, normally I'd recommend people to discover functions at 2 places
- PQ Formula Language page https://msdn.microsoft.com/library/Mt253322?ui=en-US&rs=en-US&ad=US , but I noticed that Table.TransformColumnNames isn't there yet. We'll put it soon. Sorry about that
- Typing
= #shared
in the Query Editor formula bar (this will always be up to date.)