Create a table/matrix visualization that shows a list of tables and the row count of each table

[Anonymous]

I have about 38 tables that I need to get rowcounts for and display the row count for each table. Unfortunately the COUNTROWS function seems to need me to specify the table name that I want a count for. Creating 38 separate COUNTROW measures doesn't seem to let me visualize the list in the right way either. 

I want the visual to look something like this. 

Table name	Row Count
A	1000
B	20000
C	3000
D	40000000

I have a table that has all the table names in them that could be used as a fact table. And there's the other 38 tables I need the row counts from. 

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can create a new table with the table names and then create measure to calculate the number of rows in each table.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[camargos88]

Hi @Anonymous ,

Why don't you append those tables in one ? 

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-queries

Ricardo

[Anonymous]

@camargos88 will that be an issue with 38 fairly large tables? 

But let's say I can append all the tables, then what?

[camargos88]

It's not a problem.

What is the source ?

You can append them and create measure to show what you want (table name and row count).

Ricardo

[Anonymous]

Would I need to create a new column on each table with the table name first before appending? I need the row counts of multiple tables rather than the row count of a single large table. 

[camargos88]

What is your source ?

[Anonymous]

Directquery with a SQL Database

[camargos88]

If Direct Query I think it's better using a SQL command (

select table_name, count(*) (union all queries here) group by table_name)

Doesn't it work for you ?

Ricardo