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
In this post we are going to take a look at the Power BI Date Table, how to set it up when the calendar year and fiscal year are different and show an example for each
In this blog post, you’ll learn how to setup a data gateway in Power Automate using a premium power automate subscription. Setting up a Data Gateway in Power Automate is fairly straight forward. Start by going
This post reviews the process of setting up a Scheduled Cloud Flow to pull data from the cloud to a local SQL Server using an HTTP request. The pulled data comes in the form of a
Every day, while running the Supply-Chain at Cuisine Solutions for one of our plants, our 3rd party warehouse emailed me a copy of the daily raw material inventory report within an Excel file. I’d manually save
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
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
Power BI can connect to many data sources including Excel. In the previous parts of this 4 part series, we setup the automation to populate an Excel master data file in SharePoint. Next part is to
Now that the Excel file is connected to the Power BI Service, it should be automatically be setup to refresh the report data every hour but to confirm or make changes review the steps below: Step
