How can I make SQL Request on Dataverse tables ?

(0) Share

Report

Posted on by Samny_98

155

Hello all,

I have several tables on Dataverse and I would know how can I make SQL Request on Dataverse tables ?

I don't succeed with SQL Server Management Studio because I don't know the business organization URL who is the server name. Can I use Azure SQL Database or something else ?

Many greetings.

Kevin.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

@Samny_98

You can try the SQL4CDS XRMtoolbox

https://markcarrington.dev/sql-4-cds/

Was this reply helpful? Yes No
Samny_98 155 on at

Like (0)

Report

Can I display this query file on PowerApps ? If, yes, how , please ?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@Samny_98

Sorry I don't understand the question.

Was this reply helpful? Yes No
Samny_98 155 on at

Like (0)

Report

@Mira_Ghaly
I would like to display a SQL File on Power Apps please.
I have never used a premium connector.

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

You cannot make an SQL query against online DataVerse. Access to the data is via Web Services, and as such you are limited to making Web Service/oData calls in which you can use using FetchXML or the Web API..

The XrmToolBox plugin mentioned in the previous post attempts to convert an SQL statement into FetchXML and query via FetchXML - However one of the limitations with FetchXML is that it is not 1:1 with SQL.

https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/overview
https://docs.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-data-web-api
https://docs.microsoft.com/en-us/power-apps/developer/data-platform/use-fetchxml-construct-query

Was this reply helpful? Yes No