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


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…


Check how you can easily extend the library of predefined fonts to satisfy specific customers’ requests!

https://www.pexels.com/photo/multicolored-umbrella-1146851/

I like Power BI, I really do! If you follow my articles carefully, you would have realized that I truly consider Power BI as an awesome tool — because it gives you an infinite number of possibilities to tell your data story. And, I’m not referring only to out-of-the-box solutions, but also custom-made ones.

However, I’ve recently come across an interesting problem (or, to be brutally honest, it didn’t look so interesting why I was trying to solve it). So, what was it all about?

Scenario

I was helping my client to build a Power BI report, and one of the…


Put a smile on your face and provide your DBA with all the necessary info about SQL queries generated by Power BI

https://www.pexels.com/photo/cute-dog-in-bright-shirt-on-light-background-5733428/

Once upon a time, your old scary DBA walked into your office with a red-colored face and asked you furiously: “What the hell you’ve done with your Power BI report?! It killed all of our workloads!!!”

You knew why he was angry, even before he started screaming at you. It’s because of “that” report which uses DirectQuery because your users wanted “near real-time” data…

I’ve already written why you should reconsider using DirectQuery, and in which scenarios (maybe) it makes sense to go that path.

However, it appeared that your DBA is not that “bad” as you might think. He…

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