Use the API to retrieve Database Table names

[johnmthompson]

Hi all, 

We are trying to connect Power BI Semantic Models, Dataflows, etc with the exact table they are connecting to in our data warehouse. Today we are connecting to Hadoop and using the Admin APIs I can see the connection string, but no detail on the database or table. Is it possible to get this level of detail?

Thanks!

[lbendlin]

Use DMV queries like TMSCHEMA_PARTITIONS to grab the query code for each connection. That will either give you the table name or the SQL query text.

[johnmthompson]

Where do we run those queries? I'm not familiar with them.