I am retrieving data from Dynamics NAV database via a webservice URL (ODATA V4) and including the $select option to get specific columns from the whole dataset. I do it in Power Query, either for Excel or PowerBI.
The problem though is that it is taking a hell-lot-of-time to download 1.4 MB of data, and at the same time, I get a table with all the columns, but only data in the selected columns. The rest of the columns show “error/null” values. Here’s a snapshot of the results:

enter image description here

Seems like Power Query is making the full retrieval of data and then including only the values for the selected columns.

Is there anyway to let Power Query retrieve only the data of the selected columns?
Thanx in advance for your replies

I didn’t try any solution because I couldn’t find any