Power Query : Choose columns
In Power Query, we’ve all let unnecessary columns through. With “Choose columns”, lighten your model as soon as you import.
Category: Power Query
Excel: Merge multiple files from a folder
Looking to combine multiple files with a similar structure? Achieve it effortlessly in just a few clicks using Power Query in Excel.
Excel: Import a table from a PDF file or website
Do you wish to import a table from a PDF file into Excel? Do this task effortlessly with Power Query in just a few clicks.
Power Query: Change the load options
In Power Query, have you loaded your data into a table when you only wanted to create the connection? Change your load options.
Power Query: Comments in steps
As you build your file, be sure to rename and comment out each step to keep a clear history of your thought process.
- 1
- 2