I've been working to setup some reports using Power Query by CUBE functions. It's been very convenience to setup just by typing the double quotes (") to begin a CUBE formula and MS Intellisense automatically display a drop down list of all the tables and field names in the workbook.
However, since yesterday, this intellisense function is not working. I started typing =CUBEVALUE(" and no drop-down list showed up for me to select.
Can someone tell me what do I have to do to get the smart feature back? It's really a pain to have to memorize all table and field names in order to write those CUBE formulas.