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.
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
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