Forum Discussion

pgelli's avatar
pgelli
Microsoft 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
pgelli's avatar
pgelli
Microsoft Employee
6 years ago

That is good information. Thanks lbendlin . I see that it is only supported for PowerBI premium subscriptions. 
Currently we don't have PowerBI premium. Do you know of a way which can work for us with Standard PowerBI subscription & workspace.

lbendlin's avatar
lbendlin
Super User
6 years ago

Apologies, i did not qualify that. I have no experience outside of Premium. Maybe you need to be made a workspace member?

  • pgelli's avatar
    pgelli
    Microsoft Employee
    6 years ago

    So I got hold of a premium workspace and am able to connect to the XMLA endpoint. 
    So far, I could get information like tables and columns from dataset perspective.

    We want to actually find the source table information, not the ones created in powerbi report/dataset. Sorry if that was not clear in my initial post.
    lbendlin is there a way to get the source table information and the actual queries which are used to create the dataset tables.

    • lbendlin's avatar
      lbendlin
      Super User
      6 years ago

      select * from $SYSTEM.TMSCHEMA_PARTITIONS

      • pgelli's avatar
        pgelli
        Microsoft 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.