If you have been working with Power BI for a while now you might have come across the standard Power BI actions in Power Automate. They allow you to automate (…) Read more
Create Power BI Metrics/Goals Scorecards from Excel files using Power Automate
I like Power BI scorecards a lot, as they give a really nice interface and look to your and your teams goals. However, entering all goals manually can become a (…) Read more
Recursive Flows in Power Automate – Introduction
If you want to traverse organisational hierarchies, walk through nested folder structures or create nested Power BI metrics from an Excel table for example, you need some sort of recursive (…) Read more
Forecasting with seasonality in Power BI
Today I’m starting a small series about forecasting in Power BI. In this blogpost I’ll start with a basic example about forecasting with seasonality that I will build upon in (…) Read more
Create (empty) table string from schema in Power Query
When your query returns an error, sometimes it could make sense to return an empty table instead of a simple error message. And ideally, this table has the same columns (…) Read more
Fill values to the right in Power Query and Power BI
While Power Query provides a convenient method to fill values from selected columns up- and downwards, there is no native option to do this to the right or left. So (…) Read more