topic Re: REST API - Table properties - No `columns` is returned in Developer

REST API - Table properties - No `columns` is returned

tvhung83 — Fri, 22 Sep 2017 11:59:04 GMT

Hi team,

When I called this endpoint: http://docs.powerbi.apiary.io/#reference/datasets/tables-collection/list-all-tables?console=1, the response only contains Table name, no 'columns' property is included. According to documentation, it should: https://msdn.microsoft.com/en-us/library/mt203556.aspx

Looks like it worked before: https://community.powerbi.com/t5/Developer/Get-Dataset-table-columns-information/m-p/87868#M3108, but not anymore. Is there any recent change regarding that?

Thank you.

Re: REST API - Table properties - No `columns` is returned

Eric_Zhang — Mon, 25 Sep 2017 03:00:42 GMT

tvhung83 wrote:

Hi team,

When I called this endpoint: http://docs.powerbi.apiary.io/#reference/datasets/tables-collection/list-all-tables?console=1, the response only contains Table name, no 'columns' property is included. According to documentation, it should: https://msdn.microsoft.com/en-us/library/mt203556.aspx

Looks like it worked before: https://community.powerbi.com/t5/Developer/Get-Dataset-table-columns-information/m-p/87868#M3108, but not anymore. Is there any recent change regarding that?

Thank you.

tvhung83

The REST API works as it is, I mean no columns information in the response JSON. As to "it worked before", the Dataset properties in my that reply refers to the dataset schema when creating a dataset.

Re: REST API - Table properties - No `columns` is returned

tvhung83 — Mon, 25 Sep 2017 03:32:47 GMT

Thanks Eric, then the response schema in Get Tables is a bit misleading:

Do you mean there is no way to retrieve table schema/columns after creation? I can't figure it out on Dataset dashboard as well.