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…
Do you know these nice new cars that will take you through the city jam by using electric power, while on the highway they help you to unleash the full power of the engine, by leveraging the traditional gasoline system? Sometimes the electric motor does all the work, sometimes it’s…
Performance, performance, performance…We are always striving to achieve it (or at least we SHOULD strive), but there are so many things to keep in mind when tuning Power BI reports. The first step in the optimization process is to ensure that your data model size is in optimal condition —…
In my previous article, I’ve explained how you can display images and icons on the axis and in the slicers, leveraging a very simple technique using UNICHAR() DAX function. Now, I wish to expand on that, and show how you can create ratings visual using simple DAX! …
Automating tasks — that’s something we all like! And, Power BI does excellent in that regard. Even though some of these automated things can come back to haunt you, such as Auto Date/Time option, luckily there are many more to make our lives easier.
I’ve recently played around with the…
In recent months, I was frequently asked if one should use tables or views when IMPORTING data in Power BI. I’ve intentionally marked word importing, as the main purpose of this article is to compare usage of views vs tables in Import mode. …
Just recently, I was watching Jeffrey Wang as a live stream guest with Reid Havens, and one of the dozen wonderful things that Jeffrey shared with the audience was the list of optimizations that the DAX engine performs when creating an optimal query plan for our measures.
And, the one…
By introducing Azure Synapse Analytics in late 2019, a whole new perspective was created when it comes to data treatment. …
By introducing Azure Synapse Analytics in late 2019, a whole new perspective was created when it comes to data treatment. …
