I'm using power query to pull data to excel from Business Central.
I'm trying to pull a page to link to different page and just need 4 columns - using below feed from web services with a "$select=" on 4 columns.
the data I was hoping is to get the 4 columns but instead all column headers are returned with errors.
Is this expected behaviour or am I doing something wrong?
Thanks,