Have you ever walked a “known” road, and all of a sudden, you noticed something extraordinary you didn’t see before? Well, that is what re-learning means for me: walking a known path and noticing things that probably were there before, but you didn’t see, or new things that were not there on your last walk.
Today I will start my DAX re-learning journey, and I’ve chosen SQLBI as my guide through it simply because these guys ROCK! I consider there is a consensus among the Microsoft Business Intelligence community that Alberto and Marco are truly THE DAX guys.
If you are not spending enough time on the user experience, you could be flushing down the toilet all of the hard work done in the back end.
A user recently challenged me to make the “Focus Mode” more visible; according to her, the button was hard to find for first-time users. I remembered then that many web pages’ user interface (UI) has a small walkthrough for first-time users, so I tried to replicate this in Power BI.
After a couple of tries, I got to what it can be a more straightforward process for making them:
Ideally, this screenshot…
This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.
The piece divided in a DAX and a M Query section, each bit has an identifier that is related to the sample files which can be obtained by subscribing to the PowPCo Newsletter.
When filtering multiple elements of columns, use
List.Contains in your code rather than
I believe that out in the wild exists an abundance of potential and opportunity accessible only to well-functioning teams. The organizations willing to confront the difficulties that making and keeping up top-performing groups will take advantage of these immense sources and be the ones to gather the benefits and transcend.
Be that as it may, what makes a team resilient and effective? For what reason is it so pleasant to work for certain groups but torture work with others? How do I, as a consultant, support dysfunctional teams in turning the boat? …
“If I have seen further it is by standing on the shoulders of Giants” — Isaac Newton
When talking about M Query, Chris Webb is one of the greatest gurus out there sharing knowledge for the sake of the greater good.
In 2015, Chris Webb wrote the post “Nested Calculations in Power Query,” which I have found super helpful many times; today, I want to share with you two real-life cases where it came very handy.
I will not go into detail about the code, as his original post covers this with great clarity; this post is intended two show…
It is recommended that the most important content is localized in the top left section of the dashboard.
1. Discovery call: This is around one hour call where the user shows us the current reports and data sources, here we try to understand as best as we can the needs and wishes of the end-user.
2. Wireframing workshop: this is all about the “vision.” …
I often use Embedded Power BI to test the fun stuff reserved to Premium users; I also warn my colleagues that use this capacity to remember turning it off as it becomes quite expensive to leave it on; well I left running the thing for two weeks.
How to avoid doing the same stupid mistake
After confessing my sin to my boss, and being thankful for not being killed I started investigating how to programmatically avoid doing knucklehead stuff; fortunately, we live in a world with APIs and Power Automate.
For doing this we will need to:
1) Register an…
It is a good practice to include in your Power BI reports when was the last time the dataset got refreshed. There are several techniques for doing so.
Below, you will find two of them, both arriving to the same objective, a table with a single column containing a datetime field that updates every time the dataset refreshes.
This is my favorite way of getting the last refresh time, because you do not have to deal with time zones adjustments. Only need to replace “Europe” for the continent we are interested in, and “Zurich” for the city.
It doesn’t matter if it is a drawer, room or a Power BI dataset, it is horrible to open any of these and finding a mess; then, you have to spend time searching for things that are not where they suppose, trying to decipher what the hell does anything mean, and in general wasting valuable time in cero value activities.
I consider a fundamental virtue of any BI professional always to aim to make a model that can be easily understood and worked by other users. We can perform multiple activities to achieve such a goal. …
By using and digging into the Clockify Power BI Template you can learn many things:
There is a hidden functionality: now you can also use the “reports endpoint” this tables are not enables for load as some personalization will be needed; if you are interested, please go to the Query Editor and search for the tables named “Reports Base” and…
Consultant, Business Intelligence, data, and analytics.