If you are opening a CSV file or an Excel file with only one worksheet, the navigator screen will not appear. Power Query will open a preview screen, as shown in the screenshot “Navigator Dialog Box ...

Getting Started with Power Query. 1. Open Excel and ensure that the Data tab is visible. If it is not, you can enable it by going to File > Options > Customize Ribbon and checking the Data box.

Excel provides a handy feature called Enable Background Refresh in Power Query’s properties. This feature keeps updating imported external data continuously while you may work on other worksheets.