Category: Power Query

I shared how to get data from OneDrive or SharePoint into Power Query in a previous post. Many people noted that the method shown in that post works with OneDrive for Business but doesn’t work with OneDrive Personal. So, in this post, I will demonstrate the technique needed to connect Power Query to files in Read More

In Power Query, when we connect to a local file, it’s reasonably obvious how we do that; it’s built directly into the UI. We just need to navigate to the location… Bam. Done! However, what if we want Power Query to connect to a file on SharePoint or OneDrive? How do we do that? It’s Read More

If we use Power Query to load data into an Excel Table, we may encounter an annoying default setting, whereby Table columns resize every time we refresh the query. It isn’t a problem if this is just data used for other calculations. However, if the query is part of your reporting, it may not display Read More

Filtering in Power Query reduces the table to include only those items which meet specific criteria. However, Power Query doesn’t have an option to filter to include all items. In Excel, we can use the asterisk ( * ) as a wildcard character to match any text. Therefore, if we want to include all items Read More

Knowing when our data was last refreshed is essential. It lets us know whether everything is up-to-date. So, in this post, I’ll show you how to get the last refresh date and time using Power Query. This post is in response to a Power Query question I received from Christian: “I use a CSV file Read More

Power Query in Excel and Power BI has an annoying default feature that automatically applies the Changed Type step even if we don’t want it. It generally occurs when creating new queries from non-database sources, but it also appears after some basic transformations. In this post, I want to show you how to stop the Read More

Power Query is great for extracting data from a source, reshaping it, then loading it into Excel. A standard part of the transformation process involves Power Query using column headers to reference each column. When the column headers change in the source data, it gives us a big problem. Recently, my friend, Celia Alves released Read More

Imagine a scenario where you have two or more lists in Excel and want to create a single table of all possible combinations. The question might come in a simple form, such as: “How can we get a complete list of all General Ledger and Cost Centre combinations?”.  Sounds simple, right?  There must be a Read More