Mail-Enabled Security Groups explained: how to create and use them in Microsoft 365

October 6, 2024
Denis Selimovic
Microsoft 365comment 3Created with Sketch Beta.0 comments

When we work with Azure products such as Power BI or Fabric, we occasionally come into contact with different types of access within Azure. Usually access is managed with Entra Security Groups or M365 Groups.But did you know, that there are also other types of groups within Entra? There are multiple other type of groups,…

Read full article

The best Power Query and M documentation – Introducing PowerQuery.how

March 11, 2024
Denis Selimovic
Power Query / Mcomment 3Created with Sketch Beta.0 comments

A good documentation is essential in order to work efficiently in IT. Sometimes a software manufacturer does a good job and sometimes there are alternatives, that do an even better job. Since a long time there is an amazing alternative documentation to DAX with dax.guide, but there was absolutely no alternative Power Query documentation -…

Read full article

Trace Queries in Excel Power Pivot using SQL Server Profiler

December 29, 2023
Denis Selimovic
Power Pivotcomment 3Created with Sketch Beta.0 comments

Although most of the articles in this blog are dealing with Power BI, we should not forget that the technology of Power BI is also available in Excel. There it’s just called Power Pivot, but behind the different user interface, it’s more or less the same as Power BI. Power Pivot is Power BI in…

Read full article

WhatTheFact.BI YouTube channels (yes plural!) are here!

September 15, 2023
Denis Selimovic
Blogcomment 3Created with Sketch Beta.0 comments

I am thrilled to share some big news that’s been in the works for a while now.As part of our commitment to provide you with the best Power BI resources and tutorials, we’re expanding our horizons by launching not one, but TWO YouTube channels! Why another YouTube channel? As you might have realized, there were…

Read full article

Easy week over week comparison in Power BI with the new OFFSET function

July 16, 2023
Denis Selimovic
DAXcomment 3Created with Sketch Beta.9 comments

In data analysis a common requirement is to compare your values of one week to the ones of the previous week. Such a week over week comparison gives important insights as you compare a bigger timeframe and can – without waiting for months – still see where the trend is going. How to handle the…

Read full article