Forum Discussion

johnmthompson's avatar
johnmthompson
New Member
2 years ago

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 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!

Need Help

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.