Is there anyeasy way to get the number of dataverse table rows using the UI ?
Thanks @srx_nstratton that's brilliant. How have I not discovered this before?!?!?
Here's the official MS documentation: Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Learn
FYI I didn't need the port number and the authentication in the latest (v20.1) SSMS is "Microsoft Entra MFA" - if you have MFA required.
I know the OP asked about getting this in the UI and this is not that but handy to know, that similar to @powerH I connected to the database directly using SQL Server Management Studio (SSMS). To connect use the address of your server, without https://
e.g. mycompany.crm3.dynamics.com,5558
Select Azure Auth and MFA if you need it.
Then use a SELECT COUNT(*) FROM MYTABLE to quickly get the results, about 4 seconds for a 9 million row table for me.
That's really cool, but feels like bit of a security risk. Any chance you can make the code available, so we can host it ourselves and not have authentication/data going via your website?
Thanks
Craig
I don't know what limitations it has, but if you select "edit -> edit in Excel", then open your dataverse table in Excel, then scroll or jump to the end of the Excel file, it will give you a row count :).
Edit: the limit on Excel is 100,000 rows. None of the above solutions seem very "citizen developer" to me, so I wrote a Power Automate flow that gives the answer. It's really basic. You list the rows, then compose the length. Don't forget to turn on pagination in the list rows step or it will limit the records to 5000. This has the same 100,000 row limitation, unfortunately.
Maybe a little late to respond but I have created a browser-based tool for the same. https://AshishVishwakarma.com/DataverseRowsCounter/ Please have a look.
Hello @abouchaalaBAIT ,
It is indeed the Unique Name from the Developer Resources:
Make sure that TDS endpoint is enabled in your environment settings:
Best regards
Hauke
Unfortunatly, it doesn't work for me
Hi @abouchaalaBAIT ,
I suggest to use a Power BI DirectQuery dataset in a Dashboard for this purpose.
1. Create a new Power BI Dataset in Power BI Desktop using a SQL Server DirectQuery (TDS endpoint) to your environment.
2. Use a simple "select count(*) alias_column from dataverse_table;" as a SQL Statement
3. Import the created dataset into Power BI Workspace and save. This will create a new Power BI Dashboard for you.
4. Go to Dashboards > New > Power BI Dashboard.
5. Select the workspace you created the Power BI Dashboard with the DirectQuery datasource and click on Save.
6. When the Dashboard has been created, you can open the report and you will see the total number of records in the report. The number is based on the privileges the user has. A system administrator will see all rows in the table being returned.
Best regards
Hauke
Hi @abouchaalaBAIT ,
When building the chart try selecting a view (for the preview) that will have limited records, you should be able to create the view and then still see the chart live on the view with all records. Please let me know if this does not work...
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional