Hello i need to find out if there are any sql queries that I can perform in order to get the same data in a report. I tried getting the data in xrmtoolbox but couldnt find a report entitiy to match. I just need some way to compare the data i get from dataverse to the report im pulling up
This is how I get it:
https://admin.powerplatform.microsoft.com/analytics/
go to environments on the left side menu
pick prod environment
go to left sife menu again and select Analytics and select Dataverse underneath
Admin Portal >> Analytics >> Dataverse >> Filter For 1month >> Download
Go to the middle f the screen where it says the following:
Showing data for <PROD ENVIRONMENT> from 8/15/2022 12:00 AM to 9/13/2022 9:00 AM Change filters
Select Change Filters and pick the last 30 days
Go to Dowlnloads and Select Most Active Users performing operations
The report will download to your Downloads folder