How to easily get number of rows in Dataverse Table

Like (1) Share

Report

Posted on 4 Oct 2022 09:41:51 by abouchaalaBAIT

930 Super User 2025 Season 1

Is there anyeasy way to get the number of dataverse table rows using the UI ?

Categories:

Microsoft Dataverse

All responses (12)

Answers (1)

Craig_Humphrey 166 on 27 May 2024 at 00:17:17

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

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.
srx_nstratton 76 on 26 May 2024 at 23:36:10

Like (1)

Report

Re: How to easily get number of rows in Dataverse Table

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.
Craig_Humphrey 166 on 22 Feb 2024 at 04:30:50

Like (1)

Report

Re: How to easily get number of rows in Dataverse Table

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
carlilelance 351 on 26 Jan 2024 at 17:52:49

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

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.
Ashish Vishwakarma 7 on 22 Nov 2023 at 20:30:41

Like (1)

Report

Re: How to easily get number of rows in Dataverse Table

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.
Hauke Jacobsen 64 on 04 Oct 2022 at 17:50:56

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

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
abouchaalaBAIT 930 Super User 2025 Season 1 on 04 Oct 2022 at 14:19:20

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

Thanks @powerH ,
Databasename should match my envirement name, right ?
abouchaalaBAIT 930 Super User 2025 Season 1 on 04 Oct 2022 at 14:06:41

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

Unfortunatly, it doesn't work for me
Hauke Jacobsen 64 on 04 Oct 2022 at 13:41:44

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

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
Drew Poggemann 9,278 Most Valuable Professional on 04 Oct 2022 at 10:29:12

Like (0)

Report

Re: How to easily get number of rows in Dataverse Table

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...