Adding Public Holidays to your Power BI Calendar
Not just about adding Public Holiday Flags to your Power Query Calendar Table but some Power Query techniques and at the end some advice to ensure your refresh works.
Link to Access Analytic Templates
https://accessanalytic.com.au/free-ex...
Link to my video on Calendar Table
Link to my video on Time Table
Did you know I've written a new-comers guide to Power BI "Power BI for the Excel Analyst"?
https://pbi.guide/book/
00:00 Intro
00:27 Downloading the Calendar Table
01:35 Connecting to a website
02:22 Cleaning Data Techniques
06:56 The Calendar Table features and merging the Public Holidays
09:40 Tip on Refreshing From Web Successfully after publishing
11:05 The Failure Notice - Data Gateway Required
Connect with me
https://wyn.bio.link/
https://accessanalytic.com.au/