Power BI

Power BI started as a self-service tool and has become a part of the enterprise reporting tooling. Managing reports centrally can be done with Azure DevOps.

The job function, market, structure, and role definition in the world of Business Intelligence had big changes throughout the past few years. The big change from traditional BI to self-service BI is not just about tools, but also about roles, and jobs, and organizational structure. In this post, I am sharing my views on this…

Understand different techniques to help reduce the data loaded into Import models.

Multiple patterns on how to tackle things with DAX vs with Power Query in terms of column creation and which approach is the most optimal.

A lot has already been written on aggregations and it is one of the most exciting features of Power BI in a while. The guys at SQLBI did a session...

From the day Microsoft made the "PowerBI - Refresh a dataset" Power Automate connector available, and having seen this video by GuyInACube https://guyinacube.com/2019/10/24/use-microsoft-flow-and-other-options-to-refresh...

When designing your model you will in most cases need a date dimension and one of the things you always should do is set the Summarization of the number columns in your table to none instead of the…

Yes! It is possible to use incremental refresh with files that are hosted in a folder either locally or in SharePoint. This article gives you the general pattern to carry it out.

The new Get-PowerBIActivityEvent has got some new columns which allow for better reporting insights which is shown in this blog post.

This is a new post of the Bad Practices in Power BI series – This time we discuss the momentum of Power BI and what you can do about it (or fail to). In Power BI’s 4th birthday celebration, Arun Ulag, the general manager of the Power BI product team shared a stunning visual. On …

I have previously written about how to sort a column by another column, and I used Month Names as an example. However, still, many are unaware that the same technique with slight modifications can be applied to any other columns. You can have a text column in your slicer (product category for example), and sort…

The purpose of this tutorial is to analyze and compare the market value of companies over time. To do this, we will see step by step how to download data from the Yahoo Finance site and then how to import this data into Power BI and process it in order to create a report. Step I: Downloading data ...

January was a rockin month for us over at PowerBI.tips, we were itching to release as much content as possible after the holidays! Each month we release our newsletter which condenses all of the content we produce each month into a single notification. We'll be cross posting our content here on the ...

In Part 1, I already explained what the reason behind this demo is, and what I used it for in my presentations. I made a start with the demo and showed you how to make a Form and set up a streaming dataset in Power BI. In Part 2 of this blog series I will show you how to glue it all together with Po...

This post is about a tool which converts a Power BI dataset to a Power BI Dataflow. I have analyzed the internals of PBIT files and Power BI Dataflow JSON files in depth and created a PowerShell script which converts any PBIT into Power BI Dataflow JSON. TL; DR https://github.com/nolockcz/PowerPla...

Hello, powerbination! These days, sports statistics are one of the most demanded data types around the world. Betting, fantasy leagues, ads – are the great contributors of sports stats. Let’s look at the first (and maybe the simplest) task for all data pros who are facing this complicated industry –...

One of my favorite things to do in Power BI is get creative with bookmarking, and last week I received a question that made me think of this idea. Essentially, I was asked if it is possible to use …

In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosy…

Ever wonder which fields / visuals are used in your report. Stephanie Bruno has developed an amazing tool, the Power BI Field Finder for this, check it out.

Reading Time: 2 minutes Many organizations deploying Power BI rely on one or more standardized template (.PBIT) files. Especially when paired with a custom theme, templates help create consistency for branding or other reasons. Perhaps you want to open the same PBIT (or PBIX) every time you open Power BI and don’t want to rely on finding and opening…

We all know there are lots of data sources; flat files like Excel files, CSVs that you import from another data source, connecting directly to a SQL Server or to SharePoint, or using a data warehou…

Aggregations is one of the key feature in Power BI and it helps to analyze large datasets without any performance impact.New to aggregations? read this to get a better idea. once we designed aggreg…

Recently I’ve been working with the Power Query team to come up with some ways to help developers understand the data returned by the new Power Query diagnostics functionality. In this, the f…

Technical articles, content and resources for IT Professionals working in Microsoft technologies

Here is another interesting use case of Row Level Security (RLS). It’s funny that my first post was also about RLS – when you use RLS, lot of different challenges show up (which are not…

A question I’ve received a couple of times recently is how to override slicer selections in Power BI visuals. Or more specifically, if the user selects a specific item in a slicer (or filter)…