Forum Discussion
Auto-rename all Query columns e.g. to remove underscore
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.)
arify, may I ask why you don't see any sort of intellisense coming soon? This is well out of my wheelhouse, but it seems like with the strong similarities to F#, a lot of the work will have already been done by th VS team.
Is it just low priority or am I missing something?
greggyb, intellisense for M is definitely coming. It's got a slightly lower priority but we constantly talk about it.
There's also an user voice thing for it:
pqian, thanks much. I don't get enough time to review the user voice ideas that much. I've added some votes to that item.
I'm actually still learning Power Query, but I like very much what I see. I'm still learning its performance characteristics and what good idioms are, but it's a fun process.
