API extension (?parameter?) to allow 'labels' to be returned not just 'names'

[nat]

@nat

an in-between step that would massively help would be to at least have a flag to include/exclude groups from the ‘name’ key.

This in-between step (allowing user to specify whether or not groups appear in the API response) would also help with the situation below. @Josh should I log a separate Suggestion Box item for the groups/no groups flag do you think?

All columns do not appear when connecting to powerbi

@wroos sorry for my slow response - agree starting with a list of all the column names could be useful - however in the case of JSON vs csv source in PBI, as the JSON needs to be expanded in order to access groups/repeats then there’d be a bit of manual work to figure out that logic. Also, the JSON always returns groups in the field names, can’t find a param to turn that off. @tomisin do you have any repeats in your data? As far as I’m aware, csv is great for scenarios where there are no repe…