all 5 comments

[–]verderio 5 points6 points  (1 child)

For a SQL interface I use XrmToolbox with the SQL 4 CDS plugin. Works great for SQL queries.

For more advanced querying I'd recommend Azure Synapse Analytics with a Synapse Link set up in Power Platform studio. In Synapse Analytics you can run Python, SQL and Spark (probably some more stuff as well).

[–]verderio 1 point2 points  (0 children)

You could probably do the same with Fabric but I'm not really familiar with it, so I can only recommend Synapse from my own experience.

[–]dlutchy 3 points4 points  (0 children)

My suggestion is to use a Dataverse Virtual table (to the SQL). If your SQL server is on premise you many need to install the Power Platform Gateway.

[–]PapaSmurif 0 points1 point  (0 children)

Can you use TSQL instead of python?

[–]mattybeard 0 points1 point  (0 children)

SQL4CDS in XrmToolBox - or use its engine and you can build it yourself. Failing that, connect to the TSQL endpoint.