Forum Discussion
Auto-rename all Query columns e.g. to remove underscore
Meanwhile the author of "Table.TransformColumnNames" (hint: me) is crying somewhere :'( I think it came out in July '15 update.
Nice code anyway :)
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:
- Hi greggyb,
as you say the Power Query Editor is not really helpfull. This why I created my own Editor, including IntelliSense and synthax highlighting using Notepad++. Follow this link. Maybe this is helpfull for you:
http://power-bi-usergroup.blogspot.de/2015/11/creating-editor-for-power-query-with.html?m=0
Regards,
Lars
