Forum Discussion
Use the API to retrieve Database Table names
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...
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.
Where do we run those queries? I'm not familiar with them.