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

[tvhung83]

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.

[Eric_Zhang]

---

@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.

[tvhung83]

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.