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.

Do you need to combine the data from multiple different Direct Query data sources? Or, mix imported data with DirectQuery? The composite models feature in Power BI enables you to do exactly that! — If you’re talking with Power BI professionals, you may hear them talking about two different Composite model features…Don’t be afraid and don’t be surprised:) Let me quickly draw the line between the two:

Calculation groups are one of the most powerful features to reduce the data model complexity and measure redundancy! — Mastering DP-500: Direct Query in Power BI Mastering DP-500: External tools in Power BI If you’ve carefully read the previous article in this series (the one related to external tools), you probably noticed that creating calculation groups is not feasible from the Power BI Desktop, but from the Tabular Editor…

Circular dependency error is one of the most annoying things in Power BI data modeling! Learn why this is happening and how to avoid it — As you may have already understood reading my previous articles, creating a Star-schema doesn’t necessarily mean that your data modeling tasks are completed. There are many more aspects to be aware of — and, while you can sneak without fine-tuning each and every detail — some of these “details” are…

External tools provide additional functionalities and features, that will make your life as a Power BI developer much easier! — This article is the part of the series related to mastering the DP-500 certification exam: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI Become a member and read every story on Medium! Power BI is an awesome tool! There is no discussion about that. Finally, it’s been recognized as an industry leader by Gartner for a few years in a row. However, when it comes to Power BI development, there are certain features…