Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query
In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure…
Archive
Category: Excel
Business Intelligence Components and How They Relate to Power BI
When I decided to write this blog post, I thought it would be a good idea to learn a bit…
Optimising OData Refresh Performance in Power Query for Power BI and Excel
OData has been adopted by many software solutions and has been around for many years. Most solutions are using the…
Power BI 101, Report Authoring Tools
This is my last blog post in 2021. I wish you all a wonderful break and a happy new year.…