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

Automatically trigger a refresh for a Power BI Dataset when a Dataflow refresh completes. This can be achieved easily using PowerApps.

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