Using a Date Dimension in any BI solution is a must to do. Not only because users might want to do slice and dice data by different date categories such as year, half year, quarter, month, week, fiscal categories. But also because sometimes you need to do analysis based on public holidays. Because Power Query can fetch public holidays live from a web query so it is a great tool for building a date dimension. In this lesson you learn how Power Query used for generating a date dimension with public holiday fetched live.