GetTables Rest API not returning rows/columns

[arijsiddiqui]

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 

[adilraza]

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.

[lbendlin · Accepted solution]

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.

[adilraza]

@lbendlin can you elaborate what are you trying to say, i am also having this sort of issue.

[lbendlin]

"Get Tables" only returns the table names 

[adilraza]

Is there any way to get record pushed into push dataset, i want to take backup in case there is a need to update dataset.

[lbendlin]

Not sure I understand.  You can push rows, and you can query the dataset.  What you cannot do is "update the dataset". 

[adilraza]

Well there is a case in which I want to update the dataset, and get the record of that dataset and create backup of it. That why I am trying to get the rows of that dataset. But API is not returning any thing apart from table name.

[lbendlin]

there is a case in which I want to update the dataset

You cannot do that. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41

[adilraza]

Really appreciated.