cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
hansei Resolver I
Resolver I

Intellisense / Auto Complete Stopped Working

I recently uninstalled the store version of PBI desktop to install the direct download version (because I wanted the drag-drop re-order which is not available in the store version). Latest version revision {553CCBE1-56C5-4CF7-BE8D-0AD37CA36E6F}

 

Intellisense was working fine for a few days, and then became sporadic. Now, it almost never gives the auto-complete for variable/line names. And it rarely shows the matches among built-in functions. e.g. here I would expect table.re to give Table.RemoveColumns among other entries, but it doesn't.

 

intellisense.png

 

Reinstalled without any affect whatsoever. Turned off Intellisense, restarted, turned on, restarted, and no effect. Is there some cache or some trick someone has for this?

 

1 ACCEPTED SOLUTION

Accepted Solutions
hansei Resolver I
Resolver I

Re: Intellisense / Auto Complete Stopped Working

So, I've isolated the problem. Intellisense and auto-complete fail as soon as a 'try' is created without 'otherwise'.

 

e.g. if you add line 11 from this example anywhere in any query, the feature is broken in all queries.

 

textUnitPrice = try Number.ToText(Sales[UnitPrice])

View solution in original post

5 REPLIES 5
Community Support
Community Support

Re: Intellisense / Auto Complete Stopped Working

Hi @hansei ,

 

Please kindly refer to below posts for advice:

https://stackoverflow.com/questions/13982526/why-does-intellisense-and-code-suggestion-stop-working-...

https://stackoverflow.com/questions/12095102/intellisense-auto-complete-stops-working-on-vs2008

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
hansei Resolver I
Resolver I

Re: Intellisense / Auto Complete Stopped Working

I fail to see the connection between my question about the latest Power BI Desktop and some suggestions for a 7 year old version of Visual Studio.

 

Community Support
Community Support

Re: Intellisense / Auto Complete Stopped Working

Hi @hansei ,

 

Based on my test, i cannot reproduce the same issue as you said. Above are some articles for your reference, hopefully give you some hits about the M code.

If does not help, you may submit a support ticket.https://powerbi.microsoft.com/en-us/support/

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
hansei Resolver I
Resolver I

Re: Intellisense / Auto Complete Stopped Working

It seems that the problem is isolated to a single .pbix file. Others are working fine. Saving a copy (via PBI or Explorer) does not fix the issue. I tried to delete the internal Metadata file, but that made no difference either. Interestingly, Metadata was not even re-created after deletion. Any ideas other than recreating every query? 

 

2019-08-29.png

hansei Resolver I
Resolver I

Re: Intellisense / Auto Complete Stopped Working

So, I've isolated the problem. Intellisense and auto-complete fail as soon as a 'try' is created without 'otherwise'.

 

e.g. if you add line 11 from this example anywhere in any query, the feature is broken in all queries.

 

textUnitPrice = try Number.ToText(Sales[UnitPrice])

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors