Forum Discussion

pgelli's avatar
pgelli
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Get Table information from dataset Programmatically

Hi All,   Is there a way to programatically get the information of datasource & tables used in a dataset (like some kind of metadata).  I saw there is a GetDataSet API, but that works on the datas...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

select * from $SYSTEM.TMSCHEMA_PARTITIONS

pgelli's avatar
pgelli
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Thanks lbendlin. I tried that at I dont see information of actual source in response. 
I still see the information about dataset tables, not the actual source SQL tables.

    • pgelli's avatar
      pgelli
      Icon for Microsoft Employee rankMicrosoft Employee
      6 years ago

      Sorry for the confusion lbendlin .
      My need is to programatically find the list of source tables which are backing a given powerbi report.

      • lbendlin's avatar
        lbendlin
        Icon for Super User rankSuper User
        6 years ago

        That's what I gave you with the DMV query.  You need to take that M code and parse it. It contains the server, database and query.