Red Gig

Update!!! This method no longer works although there is a new Google Sheets connector for PowerQuery that is currently in beta. If you're using PowerBI, you'll need to enable the preview features to enable it. https://docs.microsoft.com/en-us/power-query/connectors/googlesheets In the interest if demonstrating how it 'did' work, the original post is provided below. If you attempt to replicate this, you'll quickly realise the website doesn't behave as it used to. (here is the original article)  Using PowerQuery to access multiple files within the same folder on a local or network drive is a game-changing feature that will almost certainly save many people hours of effort. This functionality is great if your data exists in a place that is easily accessible but what do you do if your data is somewhere less accessible like Sharepoint, OneDrive or even Google Docs? I have previously connected to data on SharePoint and found it fairly straight forward which raises the

In this example, I'll be loading a large CSV file into Excel using PowerQuery to filter the data before it is loaded to Excel to make the file more manageable. I've found a suitable file to upload from this site http://eforexcel.com/wp/downloads-18-sample-csv-files-data-sets-for-testing-sales/ where there are a range of pre-made CSV files that are perfect for this example. I've used the '1000000 Sales Records' file but any of the files on this page should provide a similar result. Although Excel can display over a million rows, in this hypothetical example we'd like to filter the source data on one country before loading it to the sheet in Excel to make it more manageable. Open Excel In the ribbon, click on 'Data' then click, 'New Query' and navigate to 'From CSV' and click on it. Locate the CSV file you wish to load and click 'Open'. Once this is done the 'Query Editor' window will open and display a preview of the file.