Error when applying a query to Power BI (cannot convert the value null to type Table)

Hello lbendlin,

Thanks for your reply and for your example file.

I am currently using the Pro version of Power BI, so I don't have access to DMV queries.

In the process I described above, the purpose of the keyword #shared is to automatically get ALL table names of my pbix file (and then to automatically apply on those tables the function Table.Names)

I've presented an example as simple as I could, but in fact,  I'm using pbix files with many tables, each of them containing many columns, and I'm looking for a solution to automatically get the list of ALL tables with ALL columns of those tables (if possible from within Power Query).

It seems to me that the  keyword #shared is an easy way to get the names of all tables, but I am very interested if you know a better way to do it!

Thanks in advance

Pruvieros