Microsoft has released a new feature to call the SQL stored procedure from the Canvas Apps 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.

In this article, will explain step-by-step process to enable the SQL stored procedure preview feature in the Canvas Apps.

Pre-Requisites:

1. Click on the below article link and create a Microsoft Edge or Google Chrome Profile.
   
   Create a Profile in Microsoft Edge and Google Chrome
   
2. Click on the below article link to create Power Apps Trial 30 days or if you have already have an Powers Apps Tenant, skip this step.
   
   Create Microsoft Power Apps 30 days Online Trial Version

Follow the below steps after the Pre-Requisites.

Step 1: Open an Existing App or Create a new Canvas App.

Step 2: Click on Settings.

Step 3: Click on Upcoming features.

Step 4: Under Preview, Click on SQL Server stored procedures to Turn On.

Feature is Turned On.

Step 5: Click on Close.

Step 6: Click on Save.

Note: I had the below Authoring version in the Canvas App.

Hope you had followed all the steps and Turned On the SQL Server stored procedure successfully in the Canvas App.

Please like and share your valuable feedback on this article and Subscribe to my blog to get my articles to your Inbox.

Below are my earlier articles that you can have a look.

How to get the Client Version of the Model Driven Apps?

How to get Microsoft 365 E3 Trial for 30 days?

How to Enable Copilot for Model-Driven apps feature in Dynamics 365 CE Environment?

[Resolved] Web resource method does not exist in Dynamics 365 CE JavaScript Error

How to Enable Blocking unmanaged customizations (Preview) feature in Dynamics 365 CE?

How to create Microsoft Power Apps Developer Plan Environment?

Microsoft Power Apps Developer Plan vs Power Apps Trial 30 days

What is Microsoft Power Apps Developer Plan?

[Resolved] PCF Field Control not showing anything in the PCF Test Environment?

[Issue Resolved] ReferenceError: Web resource method does not exist in Dynamics 365 CE Javascript Error

[Issue Resolved] Subcomponent cannot be added to the solution because the root component Template is missing in Dataverse

How to Turn Off the Modern Look in the Model Driven Apps?

How to Turn on the New modern, refreshed look for the Model-Driven apps?

Microsoft Power Apps – Apps filter feature

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

Microsoft Power Apps – Solutions filter Preview feature

How to Show the Power Automate complete Expressions?

Dataverse Error: Cannot start the requested operation [EntityCustomization] because there is another [PublishAll] running at this moment.

Power Automate Error: You should specify a contact or account.

How to get the Choice Text and Value in the Dataverse using JavaScript?

Microsoft Dataverse Low Code No Code Plugins

How to convert the Number String to Number Array?

How to Integrate Instant Plugins in the Power Automate Flow?

Power Apps – ‘actionname’ is an unknown or unsupported function in namespace ‘Environment’

Dataverse Browser V1.1.0.1 is available for Dataverse Plugin Debugging

How to Integrate Instant Plugins in the Canvas App?

How to Enable Access to Microsoft Dataverse Actions (Preview feature) in the Power Apps?

How to Create an Instant Plugin in the Dataverse Environment?

How to Install the Microsoft Dataverse Accelerator in the Dataverse Environment?

What is Microsoft Dataverse Accelerator?

How to get the Logged in User Information in the Power Apps?

How to Install Power Platform Tools in Visual Studio Code?

How to Install the Apps from the Microsoft AppSource to your Dataverse Environment?

Microsoft Power Apps Maker Portal has a new look

Microsoft Power Apps Emulator (New Feature)

How to Enable the Dataverse Offline (Experimental Feature) in the Canvas Apps?

How to set the Authoring Version in the Canvas App?

New version of Dataverse Browser is available for Dataverse Plugin Debugging

Latest Free Practice Assessments for Microsoft Certifications

Download CRM 365 V9.X Tools using PowerShell

How to set the Refresh cadence for a Power Platform Environment?

Update forms and views (Preview feature) in Dataverse

How to connect to Microsoft Dataverse in Power Automate Flow using Service principal?

How to Enable Copilot (Preview) feature in Canvas Apps?

How to Debug a Dataverse Plugin without Installing the Profiler in the Plugin Registration Tool?

How to Enable the Licenses (Preview) feature for a Power Platform Environment?

How to Enable Maker Welcome Content (preview) in Power Apps Maker Portal?

How to Enable Managed Environments for a Dataverse Environment?

How to Enable the Modern Controls (Preview feature) in the Canvas Apps?

How to Enable 2023 Release Wave 1 updates in the Dataverse Environment?

How to Deploy Enterprise Applications in the new Dataverse Environment?

What is Preview, Experimental and Retired features in Canvas Apps?

How to Enable the New Power Fx Formula Bar in Power Apps Studio?

Writing Power Fx formulas with natural language

Power Fx Formula Columns in Dataverse

Generating Power Fx formulas from examples

How to Create Dynamics 365 Marketing 30 Days Trial Version Online?

How to disable Multi-Factor Authentication (MFA) on Dynamics 365 Login?

How to Create Microsoft Power Apps 30 days Online Trial Version and an Environment?

How to Update the URL of the Dynamics 365 CE Environment?

Power Apps US Government service URLs

How to Download Microsoft Power Platform Icons?

Microsoft Dataverse and Postman articles

Microsoft Dynamics 365 Online regions list

How to Install, Connect to Microsoft Dataverse and Use XrmToolBox?

How to take the Back-Up of Dynamics 365 Online environment?

How to restore Database Backup in Dynamics 365 Online?

How to recover a deleted Environment in Dynamics 365 CRM Online?