Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

2024 release wave 1 plans for Microsoft Dynamics 365 and Microsoft Power Platform, has been published on January 25, 2024. This includes a compilation of new capabilities planned to be released between April 2024 and September 2024.

In this blog post, I am going to talk about Power Fx calls to SQL Server stored procedures feature, which is scheduled for public preview in March 2024 and is expected to be generally available in May 2024.

Feature details

• Customers can directly call stored procedures using Power Fx.
• Customers can add a SQL Server Database object to their data sources and then access Stored Procedures actions off of the database object.
• This will help customers avoid an OnStart perf hit by calling Power Automate. Similarly, they won’t have to move data in and out of collections so overall data call and update perf will be better.

🙂