Calling a Stored Procedure using Incremental Refresh in Power BI? We think so!

Posted on by Annie D

Have you wanted to use a Stored Procedure with Incremental Refresh? Patrick has a way that you can do just that!

Sandeep’s blog:
https://pawarbi.github.io/blog/power%20bi/powerquery/queryfolding/m/optimization/2022/01/25/parameter-valuenativequery-query-folding-where-clause-in-powerbi.html

Stored Procedures: https://learn.microsoft.com/sql/relational-databases/stored-procedures/stored-procedures-database-engine?view=sql-server-ver16

Sample:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2023/20230201%20-%20IR%20with%20SP.zip

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #IncrementalRefresh #GuyInACube

Guy in a CubeWed, February 1, 2023 6:44pm