BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 01 April 2015
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
How to change Close & Load options in Power Query
We're hoping to put a full tutorial on Power Query on this website soon, but in the meantime here's the answer to something which baffled me. Suppose that you have created a Power Query, and used this to load data into a data model or workbook:
The option to close the query and load the data it returns.
You then go back into the query to tweak it, and want to change how you load the data. How can you do this? The only answer I can find is shown below.
First, make sure that you have the Power Query Workbook Queries pane visible in Excel:
Click on the Show Pane tool on the Power Query tab of the Excel ribbon.
Now click on a query, and a pop-up window will show the results of the query. At the bottom left will be 3 little icons:
Click on the three dots shown to edit load options.
When you click on the three dots on the right, you can change how your query loads:
You can now change this option to load the data in a different way.
Here's the sort-of dialog box which appears:
This dialog box is much clearer than the original Close & Load options!
Well, it took me a long time to find! If there's an easier way, do let me know ...