Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? Learn on a real-life example about data model optimization and general rules for reducing data model

https://www.pexels.com/photo/aperture-blur-downtown-focus-339379/

Have you ever wondered what makes Power BI so fast and powerful when it comes to performance? So powerful, that it performs complex calculations over millions of rows in a blink of an eye.

In this article, we will dig deep to discover what is “under the hood” of Power BI, how your data is being stored, compressed, queried, and finally, brought back to your report. …


Have you ever wanted to use images instead of “regular” text on axis? Or, even within the slicer? Check this simple technique and you’re good to go!

Image by author

If you follow my stories on a regular basis, you should have noticed that I’m often trying to enhance built-in visualizations provided by Power BI. In my opinion, there are certain scenarios when you, as a Power BI developer, can go above and beyond, and push your users’ experience to a new level, using simple tricks.

Not so long ago, I was working on creating a report solution for our customer support department. Basically, support agents perform four different types of interactions with the customers — chats, emails, phone calls, and surveys. …


Extraordinary tasks request extraordinary solutions! Check how to pack 200 million rows in 18 MB of Power BI!

https://unsplash.com/photos/uu-Jw5SunYI

When you are dealing with technology, sometimes you need to accept the fact that there are certain limits — especially when it comes to resources available. And sometimes, maybe more often than not, business requests are such that it’s hard or almost impossible to implement within the current setup.

I’ve faced a quite challenging task recently — to migrate an SSAS Multidimensional solution to Power BI. The “issue” was that the client has a Pro license (which means, 1 GB model size limit), and there were approximately 200 million rows in the fact table (and constantly growing)!

I knew at…


In the final part of the Query folding series, learn more tricks, find out when the View Native Query lies, and finally spot the difference between the queries that (not) folds, backed by real numbers

https://www.pexels.com/photo/ace-bet-blackjack-business-534181/

“Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: “Query…Whaaaat?!”

Or, maybe you’ve heard about query folding in Power BI, but didn’t know how to take advantage of it in real-life scenarios.

If you recognized yourself in (at least) one of the two situations specified above, then please continue reading this short series of blog posts!

I assume you are now familiar…


In the 2nd part of the series on Query folding in Power BI, learn why people say that the devil is in the detail!

https://unsplash.com/photos/fD0pgJCvypk

“Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: “Query…Whaaaat?!”

Or, maybe you’ve heard about query folding in Power BI, but didn’t know how to take advantage of it in real-life scenarios.

If you recognized yourself in (at least) one of the two situations specified above, then please continue reading this short series of blog posts!

In the previous part of the series, we explained what is query folding, which data sources support…


“Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: “Query…Whaaaat?!” In this series of articles, let’s learn one of the most important concepts in Power Query!

https://www.pexels.com/photo/green-grass-field-with-wind-turbines-under-blue-sky-6604984/

“Will that break a query folding?” “Does your query fold?”… Maybe someone asked you those questions, but you were like: “Query…Whaaaat?!”

Or, maybe you’ve heard about query folding in Power BI, but didn’t know how to take advantage of it in real-life scenarios.

If you recognized yourself in (at least) one of the two situations specified above, then please continue reading this short series of blog posts!

Fine, you are curious to find out what is a Query folding. …


Have you ever wanted to create your own custom visual in Power BI? With little creativity, learn how to mimic the “look and feel” of the well-known visual from Google Analytics dashboard

Image by author

I’m a big fan of Power BI and I’m not hiding it! One of the things that I really like about Power BI is the extremely large collection of visuals, both built-in, and especially custom visuals from the App Source marketplace.

Honestly, it would be really hard to imagine a scenario for your data story that can’t be supported by Power BI visuals! However, I’ve recently come under a request, that I’ve had an idea of how I want to tell the story to users, but I couldn’t find a proper way of communicating numbers!

Yes, that’s the truth! And…


Bookmarks are one of the most powerful features in Power BI! But, there are some subtle options that can make a huge difference

Image by author

If you ask me, bookmarks are one of the most powerful features in Power BI! I’ve already written multiple times about bookmarks: for example, how they can help you push the filtering experience to a whole new level, or to reinvent the traditional visuals, such as card, all the way to make your bookmarks safe for “on-click” behavior.

What is a bookmark anyway?

Bookmark is a Power BI feature that enables you to capture the current state of your report page. And, you can then refer to this captured state, as a “special” page — through the Action property on your buttons, images, shapes, etc.


Have you ever tried to dynamically change the axis on your visual? It’s easier than it seems, with little DAX magic

https://www.pexels.com/photo/eight-electrical-metric-meters-942316/

A few months ago, I wrote a blog post about dynamic filtering in Power BI — and how to display different measures within one visual, depending on the user’s selection — without using bookmarks!

Last week, I’ve got a similar request from my client. In fact, this time the request was the other way around — they want to see the same metric (measure), but from different perspectives — for example, total sales amount per country and brand name, depending on user’s choice.

Again, this could have been done using bookmarks and switching between different page states. However, I’ve wanted…


Special alphabet letters can be tricky to handle in Power BI. Or not? Check this straightforward solution using Synapse Serverless SQL pool!

https://unsplash.com/photos/lNpo-WNqBo0

If you follow my blog on a regular basis, you are already aware that I prefer describing real-life use cases to writing some pure theoretical stuff…Don’t get me wrong — of course, you should be able to understand core theoretical and conceptual foundations behind specific solutions, before diving into a real fun, but solving real-world problems is something that counts in the end.

Scenario

As I live in a speaking area that has special characters in addition to a “regular” alphabet (for those of you who don’t know, I live in Austria, where the German language is being spoken), I’ve recently…

Nikola Ilic

Data Mozart — Don’t let data make noise, create music from it | data-mozart.com | https://www.linkedin.com/in/nikola-ilic-data-mozart/

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store