Forum Discussion
GetTables Rest API not returning rows/columns
Hi,
I have created a push dataset using an API i.e "https://docs.microsoft.com/en-gb/rest/api/power-bi/pushdatasets/datasets_postdataset" and then added some rows using this API "https://docs.microsoft.com/en-gb/rest/api/power-bi/pushdatasets/datasets_postrows"
Now, when I am trying to get the tables using an API "https://docs.microsoft.com/en-gb/rest/api/power-bi/pushdatasets/datasets_gettables" it's only returning the name of the table, even it should return the columns and data.
Can you pls guide me about this behaviour, is there anyway to get the data in side a table or how can i get
The documentation states: "Returns a list of tables tables within the specified dataset" . It does not claim to return the contents anywhere.
However - you can connect to the dataset with an XMLA client of your choice and get the table contents from there.
9 Replies
The documentation states: "Returns a list of tables tables within the specified dataset" . It does not claim to return the contents anywhere.
However - you can connect to the dataset with an XMLA client of your choice and get the table contents from there.
Thankyou for your response.
https://learn.microsoft.com/en-us/rest/api/power-bi/push-datasets/datasets-get-tables#table but in that document it mentions that its response is array of Table, and Table it self is an object which contains rows and columns as property.
