REST API - Not reading column names in response

[wcilliers]

Hi All,

Please advise on below. I am trying to read data from Microsoft Teams Auto Attendant. 

I configured a REST connection and I am able to successfully connect. The query is sent as a parameter encoded in Base64.

BUT, when I select data, I am not getting any column names back and row data is loaded in pivot. 

Is there a way to get the column names and ideally in the correct format?

This is what it looks like in Power BI, for the exact same query...

Any ideas?

Thank you,

Wynand