When you reference another query in Power Query you will automatically get the results of the final step. But what if you want to reference a step that sits within (…) Read more
Payment function (PMT) for Power Query
While Excel and DAX have native functions to calculate the payment amount for a loan, Power Query lacks it still. As this is a very useful function, it’s time to (…) Read more
Future Value function (FV) for Power Query
While Excel and DAX have native functions to calculate the future value of a payment series, Power Query lacks it still. So it’s time to create our own function for (…) Read more
Present Value (PV) function for Power Query
Finally 2023 is here, the year we expect Power Query function libraries to ship. This will make it so much easier to re-use ready made function than M-extensions. So let’s (…) Read more
Quick fix for Formula.Firewall issues in Power Query and Power BI
Formula.Firewall issues can hit you when designing your queries or even “out of the blue” when suddenly refreshes in the service are failing due to changes in the query evaluation. (…) Read more
“When a Power BI dataset refresh completes” trigger in Power Automate
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