topic Re: GetTables Rest API not returning rows/columns in Developer

GetTables Rest API not returning rows/columns

arijsiddiqui — Mon, 12 Apr 2021 07:14:25 GMT

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

Re: GetTables Rest API not returning rows/columns

lbendlin — Tue, 13 Apr 2021 20:01:32 GMT

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.

Re: GetTables Rest API not returning rows/columns

Anonymous — Fri, 19 Apr 2024 11:12:54 GMT

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

Re: GetTables Rest API not returning rows/columns

lbendlin — Fri, 19 Apr 2024 11:21:33 GMT

"Get Tables" only returns the table names

Re: GetTables Rest API not returning rows/columns

Anonymous — Fri, 19 Apr 2024 11:25:34 GMT

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.

Re: GetTables Rest API not returning rows/columns

Anonymous — Fri, 19 Apr 2024 15:13:38 GMT

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.

Re: GetTables Rest API not returning rows/columns

lbendlin — Fri, 19 Apr 2024 16:30:59 GMT

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

Re: GetTables Rest API not returning rows/columns

Anonymous — Mon, 22 Apr 2024 13:27:32 GMT

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.

Re: GetTables Rest API not returning rows/columns

lbendlin — Mon, 22 Apr 2024 13:44:38 GMT

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

Re: GetTables Rest API not returning rows/columns

Anonymous — Mon, 22 Apr 2024 13:51:43 GMT

Really appreciated.