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. …

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…

How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle? Check how Calculation Groups can help you to achieve the (im)possible! — Dear reader, before you proceed, keep in mind that the following example was a real-life use case! Of course, numbers and metrics in this article were adjusted not to discard the real client’s data, but the structure and overall idea is 100% identical as it was in reality!

Thinking of taking the DP-500 exam? Let’s start learning about the Power BI alternative for the Import mode — 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! As soon as you plan to get some data to work with, Power BI asks you to choose Data Connectivity mode. If you’ve read this article, or even better, started with this one, you should probably be familiar with the Import…

Hybrid tables are one of the most powerful features in Power BI! And, it’s not (just) about separating “hot” and “cold” data…You can basically leverage hybrid tables in whole spectrum of business scenarios — If you regularly follow my blog, you might’ve noticed that I already wrote about the Hybrid tables feature in Power BI. From my perspective, Hybrid tables are one of the most powerful features as they open up a whole spectrum of possible implementations. …