Designing Power BI reports is one thing, but designing for accessibility requires a whole different mindset — As you may know, the same report may look completely different across different devices. Power BI report that contains exactly the same data points, looks quite different on a desktop compared to a mobile phone. Similar applies to different persons — you have to keep in mind that your users…

Troubleshooting DAX performance is one of the most challenging, yet rewarding tasks! Learn how to leverage DAX Studio external tool to quickly understand why your DAX query is slow. — DISCLAIMER: This is NOT a deep-dive article about DAX! The main purpose of this article is to help you get familiar with various tools for troubleshooting your DAX queries’ performance. …

Have you ever wanted to enable report consumers to choose how they wish to have the data displayed? Personalize visuals feature lets you achieve this goal with just a few clicks! — Have you ever had a situation where some of your report consumers asked you to change “that” visual from a clustered column chart to a line chart? Or, to change the measure within the visual from Sales Amount to Order Quantity (yeah, I know, we could have achieved this by…

“Who sees what in the report?” is one of the key security questions in Power BI. Learn two possible ways to implement the access control — Congratulations! In the previous articles, you’ve learned how to design and build large format datasets, how aggregations can speed up your Power BI reports, and how to leverage composite models feature to get the maximum flexibility in designing enterprise-scale tabular models. Not just that, you’ve also discovered how DirectQuery works…

How changing the default value of a property hidden deeply in the Tabular model can make you a real Power BI hero — Sometimes, things happen for a reason. A few weeks ago, I was attending Benni De Jagere’s session about Power BI performance tuning at Data Grillen. It was a great session and one of the tips Benni shared was related to the IsAvailableInMDX property in Tabular models. I remember hearing about…

Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks! — Can you spot the difference between the following two report pages?

There were many game-changers during the Power BI evolution. XMLA Endpoint availability is one of the Top 3 of all the time. — During the evolution of Microsoft Power BI as an independent product (2015), from a shy challenger in the BI analytics space to an undeniable leader, there were many “game changers” — features that brought revolution instead of evolution! Composite models, Dataflows, AI-powered visuals, Hybrid…

Check this simple trick to enhance the user experience when using Fields parameter feature in Power BI — To be honest, I can’t remember that one Power BI feature caused so much hype as the Fields parameter, which was introduced in the May Power BI Desktop monthly update! Ok, the MS Build event a few days later brought some extremely cool and appealing features, such as Datamart or…

Aggregations are one of the most powerful features in Power BI! Learn how to leverage this feature to improve the performance of your Power BI solution! — In the previous article, while explaining the Composite models feature, we laid a solid ground for another extremely important and powerful concept — Aggregations! It’s because in many scenarios, especially with enterprise-scale models, aggregations are a natural “ingredient” of the composite model.