www.powp.co

For me relearning equates to the experience of walking a “known” road, and all of a sudden, noticing something extraordinary I didn’t see before.

As an already “seasoned” Power BI professional, with a pretty good understanding of DAX, today I have decided to start a relearning path in Data Analysis Expressions (DAX) and I am very excited of the extraordinary things I will learn and the “Damn, I should have done that thing differently” moments.

I’ve chosen SQLBI as my guide through it simply because these guys ROCK! …


Learning to consume APIs in power has been a game-changer for me. As I started making my first API requests, a world of data/possibilities opened in front of my eyes; today I am sharing on a condensed manner what I have learned.

The goal is to create a comprehensive walkthrough that will will bring up to speed any newbies that have never consumed data from any APIs. I also hope that people with previous experiences consuming data from APIs will find the key needed for developing more complex solutions.

It is important to notice that all the requests described in…


You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

For a couple of years, we’ve seen a boom in applications supporting dark versions of their interfaces, and there are at least two good reasons for having a Light and Dark version of your Power BI reports:

  • Accessibility: dark versions of reports can facilitate reports consumption by users with some types of visual impairment.
  • Users preference: some users prefer light-themed reports, others dark.

The way I see it, in Power BI, there are two main approaches for creating these two versions…


You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

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…


You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

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.

M Query

M-001 Filtering multiple elements

When filtering multiple elements of columns, use List.Contains in your code rather than or.


Background

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…


(Very) Simple to use Wireframing elements

Download files from here. https://bit.ly/2Jfqn5B

  1. Open a new power Point Project.
  2. Start pulling the elements you need to wireframe into the PPT slides.
  3. Collaborate.
PPT is a great tool to start wireframing

Top left.

It is recommended that the most important content is localized in the top left section of the dashboard.

Three recommended steps for wireframing your Power Platform/Power BI Projects.

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…


Importance of the last refresh time

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.

World Time API

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.

let…

Oscar Martinez

Consultant, Business Intelligence, data, and analytics.

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