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
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
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
