Answered

How to manipulate the data in SQL Database directly from Power Pages

(2) Share

Report

Posted on by orangealias

Hello,

Is there any way to have a Power Pages app working with the data (read and write) in some DB directly (e.g., Azure SQL db), w/o replicating in Dataverse? Seems there is no such functionality.

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (2)

ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report

Hi @orangealias

It is possible to interact with SQL cloud database via Virtual Tables. Official link below

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/virtual-entities/get-started-ve

FYI. Dataverse is more than SQL database which include amazing features such as File attachments, images, etc..

Hope it helps.

------------

If you like this post, give it a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
orangealias 19 on at

Like (0)

Report

Hi @ragavanrajan ,
Thank you, I agree, in many cases we may use virtual tables in Dataverse to work with DB.

But it looks like we cannot connect to the DB directly from Pages, without Dataverse, which is pity.
Regards,
A.

Was this reply helpful? Yes No
Verified answer

PaulJSwider 152 on at

Like (2)

Report

You can connect to a SQL Server database using plugins and C#. Also, if you can connect to your SQL data using Odata, you can use WebAPI.

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/tools/devtools-create-plugin

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

hi @orangealias

You can manipulate data via Portals API: Overview of portals Web API - Power Apps | Microsoft Docs

Is there any reason as to why you want to do it via SQL?

Was this reply helpful? Yes No
Verified answer

Fubar 8,350 Super User 2025 Season 2 on at

Like (1)

Report

Whilst the data source is currently DataVerse (or Virtual Tables), if you have some data that you need to access from the Portal and doing so via Ajax would be appropriate then you could look at use OAuth 2.0 implicit grant flow (client-side calls to external APIs and secure them using OAuth implicit grant flow) https://docs.microsoft.com/en-us/power-apps/maker/portals/oauth-implicit-grant-flow there is a link towards the bottom of the page to some sample code on Github.

Note: they have announced are going to deprecate GET (think it was for obtaining a token) and so you will need to use POST.

Was this reply helpful? Yes No
orangealias 19 on at

Like (0)

Report

Thank you all, we will stick to the external Api calls from our portal to the cloud db.

Was this reply helpful? Yes No