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 datasets that are published using REST API. It will be practically impossible for us to publish a report using REST API given the amount of data we have. 

Any suggestions please?  

Need Help

14 Replies

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