Announcements
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.
@Samny_98
You can try the SQL4CDS XRMtoolbox
https://markcarrington.dev/sql-4-cds/
Can I display this query file on PowerApps ? If, yes, how , please ?
Sorry I don't understand the question.
@Mira_Ghaly
I would like to display a SQL File on Power Apps please.
I have never used a premium connector.
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-apihttps://docs.microsoft.com/en-us/power-apps/developer/data-platform/use-fetchxml-construct-query
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 404
timl 344 Super User 2026 Season 1
WarrenBelz 320 Most Valuable Professional
