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
Tag: Excel
Thin Reports, Real-world Challenges
I previously explained in a blog post what thin reports are and why we should care about them. I also…
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…
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.…