I want to inspire you today with some awesome navigation ideas for Power BI applications and reports through the outputs made in our amazing Enterprise DNA community. I’m going to highlight some of the best reports that are created by Alex, one our Enterprise DNA experts. 

Query folding is very effective with large databases when you are looking to improve refresh time or just to load and transform large amount of data quickly.

The query folding may occur for an entire power query or for a subset of its steps. If it cannot be achieved, the power query mashup engine had to compensate by processing data transformation itself. It is recommended to achieve efficiency in the model design by ensuring query folding occurs whenever possible.

Line chart with range of values in Power BI