Power BI

Categories: AnnouncementsPower PivotPower QueryPower BI

Handling Different Time Zones in Power BI / Power Query

What time is it right now for you? We might share the same time zone, but that is usually not the case with worldwide operations. If I say, let’s meet tomorrow at 8am. Will that be your 8am? Or will that be my 8am? I feel like I should’ve posted this blog post a long […]

Power BI Power Query
Read full article >

Using PowerApps dataflows and the PowerApps add-in for Excel

For quite a few years, I’ve been receiving one question that I haven’t fully delved into. It goes something like this: I manually add new columns to the output of my query (created with Power Query in Excel), and when I hit the refresh button, I lose everything. Why does this happen? How can I […]

Power BI Power Query
Read full article >

The ‘Get Data’ User Experience in Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). One of the services that we provide here at Powered Solutions is the creation of Power BI Custom Connectors (see here). For the past few months or so I’ve been getting more and more questions related to […]

Power BI Power Query
Read full article >

Data Visualizations in our daily lives: Tables – Part 2

Last week I started this series where I cover how we perceive Data Visualizations in our daily lives. If you haven’t read Part 1 yet, I highly encourage you to start reading it now here. I started this series with how videogames are most commonly using data visualizations. I even created a report for one […]

Power BI
Read full article >

Data Visualizations in our daily lives – Part 1

For the better part of 2019, the focus of this blog has been Data Preparation articles for Power BI / Power Query. Usually, the average data analyst spends most of his / her time on this task – making sure that the data is in the shape / form that the computer requires it to […]

Power BI
Read full article >

Data Profiling, Quality & Distribution in Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Microsoft released these features almost a year ago and in the last couple of months it has received some love with some updates. I’ve noticed that most people don’t really use these features, mainly because they’re disabled […]

Power BI Power Query
Read full article >

Grouping rows with Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). Since it’s origins, Power Query  / Power BI has had this feature called Group By and you can see it under the main menu and the Transform ribbon under the following icon: is not a really descriptive […]

Power BI Power Query
Read full article >

Fill dates between dates with Power BI / Power Query

One of my most popular posts is one about recurring dates with offset in Power Query (url). It has thousands of hits, but one of the key follow up questions that people have after reading that is “How do I fill dates between dates?” This is the post where I’ll cover that very same topic […]

Power BI Power Query
Read full article >

Recursive Functions in Power BI / Power Query

Have you ever heard about Recursion or Recursive functions?  They are present in the M language for Power BI / Power Query and this is a post where I’ll go over how to use recursion or make recursive functions in Power BI / Power Query. This is a pretty advanced topic on Power BI / […]

Power BI Power Query
Read full article >

Error handling (IFERROR) errors from Excel files in Power BI / Power Query

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you haven’t read the first two posts (Part 1 | Part 2) in this series yet, I welcome you to do so before reading this one. I also recommend that you check out this post on […]

Power BI Power Query
Read full article >

Logical Operators and Nested IFs in Power BI / Power Query

In the previous post I showed you guys how to create a conditional column in Power BI / Power Query using the UI and then just using the Power Query Formula language. In this post we’ll go over the available conditional operators and how to do Nested IFs in Power BI / Power Query.

Power BI Power Query
Read full article >

Conditional Logic: IF statement for Conditional Columns

IMPORTANT: You can read the official documentation that Microsoft has on this topic from the following link (url). If you come from Excel, you’ve probably seen or heard about the IF statements and its new sister the IFERROR. I remember the first time that I saw a conditional chain like the picture below: It looked […]

Power BI Power Query
Read full article >