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.
We all write our codes in a proper format so that readability and understanding of codes become easy. While working with POWER BI, we use DAX Expressions to write our measures and calculated columns. We know that formatting is not required in DAX. It’s normal to see DAX expressions that span over 10 to 20 -lines or more, depending on the complexity and requirements. Sometimes we ignore DAX format as it is time-consuming, and we need to press ALT+ENTER for the new line, which is out of habit for all of us. There is too much ambiguity, and a lack of official specification makes it even harder to comprehend. Whenever I am working with Power BI, I use the following technique to measure it.