This post is also available in: Deutsch

When you often work in different IT environments, you can easily reach the point where a customer is working with a different Power BI desktop version than the latest one. As a developer this can become a problem, because the PBIX files are generally not backward compatible to older Power BI versions. As a result, the completed work may not even be accessible to the customer.

Why the download from the Power BI Blog does not work

In the past I used to google for the wanted release article in the Power BI Blog and then download the file there. Unfortunately, this approach no longer works, as the links now all point to the latest release. This may be good for end users, but as soon

This post is also available in: Deutsch

In my first blog post, I briefly mentioned that my digital notebook – in the form of OneNote – is well filled with plenty of notes and approaches that I want to share here on the blog.

One category is DAX and M code snippets, which I use regularly. For example, creating a date or time table or creating ID columns from a date and other similar things. Simply approaches that you need again and again, and give you a bit of a headache every time you have to rethink them again.

So I came to the decision that I share them here on the blog as well. For this purpose I have created a separate page with all

This post is also available in: Deutsch

If you want to combine several tables, you have to ask yourself whether you should do this already in the data source such as SQL Server, in the processing of the data (ETL) in Power Query or in Power BI and, above all, where exactly there is a difference.

First of all, the post is relatively detailed, for all of those who consider it too long (tl;dr) here is the comparison table:

Duplicate entries remainDuplicate entries are removedUnequal number of columnsDeviating column namesDifferent order of the columnsCombine more than 2 tables
UNION in SQL ServerWith UNION ALLWith UNIONxx
APPEND in Power QueryxPossible with “Remove duplicates”xxx
UNION in DAXxPossible with “DISTINCT”xx
Overview of the different possible combinations

Data transformation in the data source or in the frontend?

A question that

This post is also available in: Deutsch

What at first sounds complicated and not very useful, can be found in reality from time to time. Recently the automated export of source data from another program in CSV format confronted me with this task.

Daily folder for automated export

Unfortunately, when exporting from the source system – apart from the target directory – very little could be adjusted. The result is that the automated export job daily creates a new folder with the current date, similar to the following example:

In this example it is only necessary to load the files from the newest folder, because this folder contains the entire data. However, the file names also change

This post is also available in: Deutsch

In yesterday’s poston the Power BI Blog, Microsoft announced the upcoming Power BI Premium for individual users.

The advantages of Power BI Premium compared to a normal Pro Account are quite clear: 48 refreshes per data set per day compared to 8 refreshes with the Pro License, automated machine learning possibilities, cognitive services, the up to 16 times better performance (according to Microsoft) and the significantly higher limit for the size of data sets offer among others a huge added value.

Premium up to now only affordable for large companies

The problem so far is that Power BI Premium starts at 4’995 USD – noted per month. This corresponds to the financial expense of about

This post is also available in: Deutsch

In times of Corona we have to take other ways to avoid the gathering of larger crowds.
Such as Microsoft, which is setting this year’s Ignite from 22-24.09.2020 as an exclusively virtual event. For Europeans maybe not even the worst decision 😉

You can register on the Ignite website:
https://myignite.microsoft.com

According to the PBI blog the following sessions are about Power BI:

Live Sessions

Microsoft Power Platform: Fill the app gap and supercharge organizational agility
Live Tuesday Sept 22: 9:30 – 9:50 AM PDT
Replay Sept 22: 5:30 – 5:50 PM PDT
Replay Sept 23: 1:30 – 1:50 AM PDT

Deliver insights where decisions are made with Power BI
Live Tuesday Sept 22: 12:15 – 12:45 PM PDT
Replay Sept 22: 8:15 – 8:45

This post is also available in: Deutsch

Automatic scaling of metrics or measures is possible in Power BI for just about any visual. However, there is currently no possibility to dynamically adjust tables or the matrix.

No dynamic scaling option for table and matrix

With this selection the values can be displayed in millions, for example.

Even if the values are restricted due to a slicer, filter or drill down, the manually set scaling is kept. Depending on the constellation, this leads to the strange situation that no more information can be obtained from the report because the values are too low for scaling.

This post is also available in: Deutsch

Hello everyone,

it is the middle of September and the vacation is slowly coming to an end. I had the time to think and am highly motivated to start something new. My digital notebook is well filled with all kinds of topics that I deal with in my daily work around BI and specifically Power BI. In my experience with clients and colleagues, sometimes we all hang on the same question. I don’t want to keep my knowledge to myself, I want to share my experiences, I will start a blog!

Where will the whole thing lead to? No idea at all! Does it add value for the reader? Also no idea. Will there even be readers? At least one, if you made it to these