question

49114189 avatar image
0 Votes"
49114189 asked ·

Power Query Merge dialog box blank

I am having a problem with Excel / Power Query that I had once before back in 2018. The only solution that worked then was to re-image the hard disk.

The problem manifests itself in two ways:
1) When I open Power Query it is just white and the table does not show.
Cannot close the PQ pane with the X have to press Alt F4 twice.
Open PQ a second time and you can see the table of data.

2) When I try and do a merge the drop down selector for the second query is blank.
To do a merge I have to use the Advanced editor.

I have just had our IT dept completely uninstall O365 with a Registry clear out. The re-install.
Still had the same problem.

The fact that the only solution last time was a HD re-image makes me think that the problem is not in Excel / PQ itself. But it does not like something on my machine. Though nothing has been installed recently.

I have just installed the latest version of Office v2101 (build 13628.20274.

power-query-desktop
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Ehren avatar image
0 Votes"
Ehren answered ·

We have heard reports of this from time to time but we have never been able to narrow down the cause. Other than doing what worked last time (which is a pretty heavyweight solution), I would recommend that the next time this happens you:

  • Send feedback from within Excel

  • Check to see if Excel is running low on memory





·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

49114189 avatar image
0 Votes"
49114189 answered ·

Thanks for the reply.
It is not a case of "when it happens again" it happens all the time. Every now and then it does not happen.
Memory is fine. It is happening at the moment using less that 50% of 16 gb.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.