cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
richard-powerbi
Post Patron
Post Patron

IntelliSense struggle in Power BI

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 😞

 

 

7 REPLIES 7
v-eachen-msft
Community Support
Community Support

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

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Mariusz
Super User II
Super User II

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

 

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

@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 #""?

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

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

 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors