Directly Query a Power BI Dataset Using Power Automate and Save it to Excel in SharePoint
Intro: I received a request from one of my viewers for help in developing a Power Automate flow and after completing the flow decided to do a blog post and YouTube video on it. The Request: I decided to take it one step further by removing the need for the Power BI Export button and […]
How to Export a Large Filtered SharePoint List into a CSV File Using Power Automate
In the previous post I imported 100,000 rows of data from Excel into a SharePoint List using Power Automate. In this post, I will export a large amount of filtered data out of the same SharePoint List and into a CSV file using Power Automate. Within Power Automate, I’m just using a manual trigger and […]
How to Import a Large Excel Dataset into SharePoint Using Power Automate
In this blog post, I discuss how to import 100,000 rows and 56 columns (5.6m data points) into a SharePoint List (Microsoft Lists) from a Microsoft Excel csv file using Power Automate. I downloaded a 1.8 GB csv dataset from Kaggle with 495,000 rows and 89 columns and transformed the data into two 50 MB […]
Link Notes to a SQL Server Table in Excel Using Power Query
While working at Microsoft I had access to the SQL data from many of the applications used by the Azure Capacity Planning and Supply Chain teams. One of my functions was to track the changes and movement made to capacity (server racks) across time. To accomplish this, I used Power Query in Excel to link […]
Copy Email Attachment Excel Content to SharePoint and Rename Using Power Automate-Series 1 of 4
Power Automate can help with moving email attachments from an email account to SharePoint. In Part 1 of this 4 part series, we are going to walk through the steps on how to setup a Microsoft Outlook rule to move an email with an attachment to a specific folder in Outlook, copy its contents to […]
Copy Excel Content (Dynamic) from one Excel file to Another using Power Automate-Series 2 of 4
Moving content from one Excel file to another is a common task that Power Automate can do rather effectively. In Part 2 of this 4-part series, we are going to go through the steps on how to copy the contents from one Excel file to another when a file is created in SharePoint. This other […]