cancel
Showing results for 
Search instead for 
Did you mean: 

Power Query Intellisense not working well

Having an 'auto complete' feature in a coding language is great.

When it work right.

Power Query auto complete does NOT.

 

Try this: Open a query and click the Custom Column on the Add Column menu. The dialog box opens where you input your M language statement.

Now type into the formula box "Text.Combine" and see the suggestions it brings up and more importantly WHERE IN THE LIST it places the highlight. If you're fast on the keyboard and hit the TAB key without looking at the suggestion it gives, you will get "TextTable.Combine". 

What is TextTable.Combine? That's not even a Power Query Function. It an erroneous amalgamation of the FISRT word I typed plus the full command that it chose.

 

Look at the screen shot below and note the SUGGESTED row it highlights (the one it will take if you simply hit <Tab>) as opposed to the one three rows below it THAT IS AN EXACT MATCH OF WHAT YOU ARE TYPING

 

Power Query M Auto Complete.png

 

 

Seems Intellisense cannot match on the entire phrase, but only looks at the last word after the period?

 

After typing "Text." I shouild see a list of all the functions that start with "Text." not ones that start with other words.

 

I see this as a bug

 

 

Status: New
Comments
Community Support

@ToddChitt ,

 

After test actually as you said PQ Intellisense currently doesn't match your function, you need to press down arrow in keyboard to locate the function. Or you can input "Text" then press down arrow in keyboard though some class has much functions like "List". 

 

Not sure if this can be considered as a bug or by design issue, I would suggest you create an idea here to help power bi improve.

 

Regards

Jimmy Tao

Responsive Resident

@v-yuta-msft 

Thanks for the quick reply. A couple of points I would like to make:

A) The title of the post is "...not working well", not "...not working". It works, just not like one would expect, like one would see when writing C# code in a Visual Studio project. I did VBA programming in MS Access 20 years ago and THAT intellisense was smarter than this one.

B) I still call it a BUG. Why? The general definition of a BUG in software is that you take a certain action and you expect a certain result, but get a different result. Consistently and reproducable by others. I have spelled out my actions, expectations, and actual resulsts in the post.  If Microsoft is going to classify this as BY DESIGN, then we'll open up Point C:

C) MICROSOFT made the design specifications for this feature, and MICROOSFT built it. MICROSOFT can CHANGE the specifications, right? It's the same general principle around why the cars we drive today get an average of 30 miles per gallon when the average was half that 20 or 30 years ago. Comparing later years, we now have air bags, and seat belts, and tires filled with air instead of solid rubber. Auto manufacturers CHANGED THE DESIGN SPECIFICATIONS of their cars, then they BUILT THEM ACCORDING TO THOSE SPECEFICATIONS, with the result being better cars.

 

I'm going to hold my ground and NOT post this as an idea because, I consider it a BUG, not a request for a new feature or improvement. MS should be looking at BOTH forums and making decisions accordingly. Known BUGS shouldn't need VOTES to get them noticed by the program managers. 

 

Responsive Resident

Addendum on the behavior of the Intellisense in Power Query:

If you type in "Text.Combine" to get the screen shot above, and then CLICK on the item that exactly matches the text you typed, you will get the following: "TextText.Combine"

 

If that's not a bug...