Power BI

New documentation about what’s involved with migrating to Power BI is available on the Microsoft Docs site.

[vc_row][vc_column width="1/1"][vc_single_image media="87927" media_width_percent="100"][vc_column_text] Complete blog post to be released following the 4th part of the series. Part 3 Power […]

Power BI Sidetools is a free Power BI external tool intended to increase productivity during reports development in Power BI desktop. Transfer DAX and M formulas to files With just one click, you can transfer M and DAX formulas into a folder named like your report. The very first use case wil...

Learn how to plan and conduct a migration from another third-party BI tool to Power BI.

Back in May 2020, I wrote a blogpost about visual customization in Power BI reports. The feature was released in preview with the April 2020 release. Now, the Power BI team made another update to t…

The last two videos in our series on building a data culture covered different aspects of how business and IT stakeholders can partner and collaborate to achieve the goals of the data culture. On…

This article describes how to create Key Performance Indicators (KPI) in a Power BI Desktop data model by using Tabular Editor. Starting from the July 2020

BI Polar has a series of videos and accompanying blog posts that focus on key aspects building a data culture. This series is in progress – five videos have been published so far, and more vi…

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

How to increase Power BI adoption in your organization.

When starting a Power BI project, you have many choices to make. Decisions like how to source your data, where and how to create queries to cleanse, transform and reshape the data; where and how to…

You probably know that dimensional modelling and building a star schema are very important in Power BI. In a star schema you’ll have at least one fact table, and in your fact table you’…

These days more and more data lives behind an API, rather than in a more traditional data source like databases or files. These APIs are often designed and optimized for small, chatty[1] interactio…

Microsoft released the exam DA-100 (Analyzing Data with Microsoft Power BI) around early April 2020 which was in Beta until around the beginning of July. After the exam become out of Beta, I was wo…

I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let's see how this is possible. Sample model I have a…

I often get this question: "Is it better that I create this calculation as a snapshot table in Power Query (or T-SQL, or the data source), or write DAX measures for it?" If you ever had a scenario of creating a report of snapshots, you know what I mean. "Should I have a table for…

I always try not to overload my music with orchestration and to use only those instruments that are absolutely necessaryAbel Korzeniowski This is where the analogy starts with orchestration, to whi…

This trick was demonstrated in my last session at RADACAD channel: The idea is basically to copy the entire report (pages, filters, bookmarks,…) between two different Power BI Desktop files (…

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

Introduction This article is an update to one of my more popular blog articles and includes updates and corrections. Free Even though Microsoft took away the ability to share using the Free version of the Power BI Service, there is still a method available for sharing reports in Power BI. That featu...

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

In last week’s post and video we looked at how business intelligence tools have evolved, with each evolution solving one set of problems and introducing another set. The video described how s…

Not all data is created equal. One size does not fit all. In addition to collaboration and partnership between business and IT, successful data cultures have something else in common: they recogni…

LAUNCH OFFER: the books on Amazon, Apple, and Google stores have a reduced price (35% discount) until August 31, 2020. Starting September 1, 2020, the ebook

Analyze in Excel for Power BI Desktop is an external tool for Power BI Desktop that with a single click creates a new Excel PivotTable connected to the data

Learn how to use the Hot Swap connections script to change the data source location of your power bi desktop report. download the installer here.

Download the Business Ops tool to install all the External tools for Power BI desktop. Visit this page to learn about this installer.

With XMLA endpoints available in Power BI Premium and the recent release of .NET Core versions of the Analysis Services client libraries (ADOMD.NET and AMO) in public preview, you can start building modern cross-platform Power BI solutions across Windows, Linux, and macOS, and cloud-oriented environments.