Power Query - Create Table with a List of the tables in the model with row counts

[Castle1979]

Hi , I would like to create a table in Power Query that holds all the table names currently listed in the model and their row counts.

I have created this table using #shared and #sections but once i leave the Power Query Editor the functionality of these seem to change so i am unable to create a visual. 

Has anyone done something similiar?

[Castle1979]

Thanks for the response but im really looking for row counts post powerquery transformation.

[AntrikshSharma]

@Castle1979 Unfortunately, you can do much with those 2, you can load names but nothing much. If you are connected to a database you can easily do that there and load the summary table from the database.