For Azure SQL Databases there is a very cool new preview feature: “sp_invoke_external_rest_endpoint “. This function allows you to call certain Microsoft API endpoints directly from within your Azure database (…) Read more
Posts Tagged ‘Power BI’
Automatically plug or balance your balance sheet in Power BI
This article presents a method to automatically plug or balance your balance sheet in Power BI. You can use it if your bookkeeping system doesn’t contain the Profit and Loss (…) Read more
Reference an intermediate step from a different query in Power Query
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
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
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