Forum Discussion

hansei's avatar
hansei
Helper V
7 years ago
Solved

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 re...
Need Help
  • hansei's avatar
    hansei
    6 years ago

    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])
hansei's avatar
hansei
Helper V
6 years ago

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? 

 

  • hansei's avatar
    hansei
    Helper V
    6 years ago

    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])