This post is also available in: Deutsch

Today I’ m going to write a post that doesn’t directly have anything to do with Power BI, but still adds a lot of value there. For about a year now, I’ve been using Microsoft PowerToys, a combination of different tools that make your life easier.

Original idea, FancyZones to divide the screen into different areas

Actually, I came across PowerToys when I was looking for a tool that can divide my wide-screen monitor into different areas. I tested a few tools and ended up with FancyZones from the PowerToys Suite. From my point of view, it works the best of all tools and at the same time it is also free of charge.

However, what I use the most after trying out

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

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