Power BI

In December of 2019 Power BI team updated the KPI visual with a ton more features and options. This tutorial walks us through all the new hot features.

Recently I received a question on how to Unfill in Power Query - remove all duplicate instances of a value, replacing them with null

Detecting outliers and anomalies using the three-sigma rule of thumb in Power BI with no code

Continuing on our series on data culture, we’re examining the importance of having an executive sponsor. This is one of the least exciting success factors for implementing Power BI and gettin…

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...

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.

I have written another blog article previously about how to set up your Power BI to get data from a file in OneDrive for Business folder without needing gateway. That was a popular blog article, but I got questions about what if I want to get data from a folder in OneDrive for business but…

I have previously explained one of the benefits of Power Platform dataflows, which was the ability to refresh the data as many times as you want (on a scheduled basis), and the ability to refresh even with the frequency of a minute. Another useful feature of Power Platform dataflows is the ability to have referenced…

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

Managing the assignment of Power BI Pro licenses is a fundamental task of Power BI administrators. The Power BI admin, the BI team, and possibly other stakeholders may all pose a number of common q…

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…

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.

Recently, I was faced with a very interesting problem. I had developed a complex dataset. Beside that there are more than 200 reports using a live connection to this dataset. A report’s user had come and asked for negating a Boolean value of a column – because I had misunderstood the meaning of the ...

I have written previously a blog article that I explained in detail how I fetch the image URL from a website using Power Query. That method, however, is what I call a bit of a techie way of doing it because you have to look at the HTML code of the page. There is an…

Learn how to work with SharePoint Multi-value columns in Power BI! You learn the basics as well as how to set up the model to enable value filtering.

Activity monitoring and troubleshooting with the new logging API is focused entirely on Power BI tenant events like dashboard, interactive and paginated reports views, deployments, errors and data …

In Power BI the Key Influencers visualization uses multiple linear regression models. Explore these models, what exactly they are, and how they work.

Visit the post for more.

Static Tables created via “Enter Data” has non-readable code. This post provides a solution to that.

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

Different modeling approaches can speed up performance of your Power BI dataset - albeit with the tradeoff of additional complexity. One situation is where users need to access a very large dataset, but typically apply the same set of filters - resulting in a small subset of rows meeting the needs of most queries. A sliced aggregate approach (implemented in the data model + DAX) can be used to make your models performant where they need to be, but still allow the full range of reporting.

This article describes the reasons why an Excel pivot table may be slow when using the Analyze in Excel feature of Power BI. Power BI uses the Analysis Serv

Back in May 2019, I introduced the Power BI Pixel technique to track usage on Power BI. In today’s post, I will share the detailed implementation steps to help you build your own Power BI Pixel and track users and the filter selections they make in your Power BI report. Note: If you care about …

Power BI custom visuals may make your report slow to load

tl;dr – to kick of 2020 we’re starting a new BI Polar video series focusing on building a data culture, and the first video introduces the series. You should watch it and share it. Succ…

If you don't have a Power BI Premium capacity license, then you are limited to refresh your dataflows up to eight times a day, with the frequency of 30 minutes. The good news for you is that you have a way to do unlimited refreshes and with whatever frequency you like using Power Platform Dataflows.…