See data and reporting from every angle

Microsoft Fabric, Power BI and the plumbing underneath. Written from real projects, with the templates and cheatsheets to go with them.

APIs as Power BI Datasources

There is an abundance of APIs around us, and we use them in our daily routine without thinking about them anymore.

Date dimensions in Power Query

The date dimension is one of the most fundamental dimensions needed in reporting. That is because we are primarily interested in results from the p...

Dynamic windows in calculation groups

The WINDOWS function is becoming very popular because it can save a lot of time both for the execution of the calculation and for the development i...

INDEX as a friend for Conditional Format Strings

INDEX + Calculation Groups + Custom Format String Expression = Quick dynamic answers

OFFSET and its usage with Calculation Groups

December update brings officially new DAX functions into PowerBI. I was playing a bit with one of them... with OFFSET and especially in cooperation...

Restrict Power BI Integration Button in Microsoft Lists

Power BI and integration to Sharepoint Lists have been with us for some time. Some can turn them on, or only specific groups of users can access th...