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
lbendlin's avatar
lbendlin
Super User
6 years ago

You can use any XMLA client (like SSMS, DAX Studio, ALM Toolkit etc) to connect to the XMLA endpoint of the dataset (assuming, of course, that you have access to the dataset) and pull down all the meta data.

  • 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.