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.

Documentation options in Power Query

Document your code! One day you will thank yourself, or someone else will thank you, who will take over.

Dataflows refresh monitoring

Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does th...

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