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