Mail-Enabled Security Groups explained: how to create and use them in Microsoft 365
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,…
The best Power Query and M documentation – Introducing PowerQuery.how
![](https://whatthefact.bi/wordpress/wp-content/uploads/2024/03/2024_03-PowerQuery.how_-768x432.png)
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 -…
Trace Queries in Excel Power Pivot using SQL Server Profiler
![](https://whatthefact.bi/wordpress/wp-content/uploads/2023/12/PowerPivot-trace-with-SQL-Profiler-768x432.png)
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…
WhatTheFact.BI YouTube channels (yes plural!) are here!
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…
Easy week over week comparison in Power BI with the new OFFSET function
![](https://whatthefact.bi/wordpress/wp-content/uploads/2023/07/2023_07_week-over-week-comparison-with-offset-1-768x432.png)
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…