IntelliSense struggle in Power BI

[richard-powerbi]

I'm super annoyed by how IntelliSense works as described below. Does anyone know a trick?

= PreviousStep
// I want to get the row count of the resultig table in PreviousStep
// I will start typing "Table.R" right before "PreviousStep" like this:
= Table.RPreviousStep
// When I hit Tab it overwrites the value that I wanted to include, resulting in this:
= Table.RowCount
// Nooooooooooooooooooooooooooooooooooooooooooo 😞

[v-eachen-msft]

Hi @richard-powerbi ,

You could vote for this idea to improve Power Query. 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33129547-intellisense-for-m

[richard-powerbi]

@v-eachen-msft don't we have it? https://ssbi-blog.de/blog/technical-topics-english/intellisense-for-power-query-m-finally/

I'm complaining about how it works.

[Mariusz]

Hi @richard-powerbi 

Before typing live the space in front of your step, this will allow you to use the Intellisense and keep the step, but you still will need to delete parentheses at the end of the function.

I find it annoying too.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[richard-powerbi]

@Mariusz Am I crazy or has it been fixed? 😆 I'm not having the problem anymore. Latest version from Store.

[richard-powerbi]

@Mariusz I was crazy. It has not been fixed. But it seems to work fine when the next character is a #.

So a workaround would be to make sure your steps consist of two words or manually give the step #"".

On a sidenote, anyone knows if it is possible to force PQ to give steps always #""?

[richard-powerbi]

@Mariusz yeah that's what I'm doing or sometimes I cut the value and hit tab and paste the value... was hoping there was a better trick.

[Mariusz]

Hi @richard-powerbi 

You and me both 🙂 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn