Power query not displaying tables

Hi lognvik ,

When Power Query isn't displaying your tables, is there a little stream of yellow dots tracking across the window right above the formula bar?

If yes, then PQ is trying to load your previews and is taking a long time.

I would suggest, in the first instance, to go to File > Options & Settings > Options > CURRENT FILE > Data Load and switch this off:

If it's greyed-out like mine, then go to ~ GLOBAL > Data Load and adjust this:

This will control how/when PQ downloads your previews. If you change it to never, only the table/query you are looking at will download, so should be significantly faster to view in isolation. However, it also means that when you click on the next query, you will have to wait for that one to download before you can view it, and so on.

Pete