Writing queries to the Power Platform to help with analytical work.
Pre-requisites:
- enable TDS endpoint in your env:
https://community.dynamics.com/blogs/post/?postid=dbb726b6-430e-464c-af22-424ed88bcc1a https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query
- install XRMToolBox: https://github.com/MscrmTools/XrmToolBox/releases/download/v1.2023.12.68/XrmToolbox.zip
- install SQL 4 CDS plugin: https://www.xrmtoolbox.com/plugins/MarkMpn.SQL4CDS/
- Add a connection to your environment.
Next, you simply compose your queries or use queries from this repository to get the analytics you need.