This article outlines an approach besides "View Native Query" to check if query folding is happening in Power BI / Power Query or not

We will show you how to create dates between a start and an end date using the list operator in Power Query. This can be handy as well for a

This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop

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.