Red Gig

  In a recent post, I showed you how to connect to a folder and combine multiple files on Sharepoint . This is a similar method but it connects to just one file that meets a specific rule or criteria such as the latest file with a filename beginning with a certain string. A common example of this would be where a system automatically generates a file and saves it in a folder then there is a need to analyse just the latest file. Open PowerQuery and use the 'get data' function to access the 'More…' option Select the 'Sharepoint Folder' option and click 'Connect' In the next window, paste the URL of the sharepoint site (not the folder) that contains the file you're attempting to connect to then click 'OK' In the next window, click 'Transform Data' Note, clicking 'Combine and Transform Data' will initiate the process of combining the files. As we need to apply a transformation to the list before accessing the file, we'll need

In a recent post, I showed you how to connect to multiple files in a folder . This is a similar method but it connects to just one file that meets a specific rule or criteria such as the latest file with a filename beginning with a certain string. A common example of this would be where a system automatically generates a file and saves it in a folder then there is a need to analyse just the latest file. 1. Open PowerQuery and use the 'get data' function to access the 'More…' option 2. Select the 'Folder' option and click 'Connect' 3. In the next window, click 'browse' to locate the folder that contains the file you're attempting to connect to then click 'OK' 4. In the next window, click 'Transform Data' Note, clicking 'Combine and Transform Data' will initiate the process of combining the files. As we need to apply a transformation to the list before accessing the file, we'll need to work with the metadata from the