How to easily get number of rows in Dataverse Table

(1) Share

Report

Posted on by abouchaalaBAIT

932 Moderator

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (2)

All responses (12)

Answers (1)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (4)

Report

Hi @abouchaalaBAIT ,

Here is an article providing some options: https://nishantrana.me/2020/05/27/different-ways-of-getting-record-count-total-in-dynamics-365/

What I usually do is create a basic chart for the entity with count of the primary name and the status as the horizontal coordinate and I can pull up a view to quickly see the counts with the "Show Chart".

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

Thanks @dpoggemann , apparently this does not work on large dataverse tables. I have more than 4 millions rows in a single table. Is there other options in my case ?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No
Hauke Jacobsen 64 on at

Like (0)

Report

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

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

Unfortunatly, it doesn't work for me

Was this reply helpful? Yes No
abouchaalaBAIT 932 Moderator on at

Like (0)

Report

Thanks @powerH ,
Databasename should match my envirement name, right ?

Was this reply helpful? Yes No
Hauke Jacobsen 64 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ashish Vishwakarma 7 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
carlilelance 351 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Craig_Humphrey 186 on at

Like (1)

Report

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

Was this reply helpful? Yes No