When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...

There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source

Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.