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:

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:

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: