Forum Discussion
Dynamics 365 - Odata return only selected columns
Hi,
I am connecting to Dynamics 365 via Odata Feeds as described here
https://msdn.microsoft.com/en-us/library/gg334767.aspx
When I write the following query in a webrowser
https://tenantname.api.crm4.dynamics.com/api/data/v8.2/accounts?$select=name&$top=3
I get the name of the first 3 accounts.
When I write the same query in Power BI I receive ALL the columns for the first 3 accounts.
How can I force Power BI to return only a limited set op columns.
There is a "Choose columns" option in the drop down menu which allows you search and select specific columns. Makes life a little bit easier.
6 Replies
But I believe this solution it not fix the problem... I meant... If you want to retrive only the select columns on the query to minimize the retrive time, then this option it is not the best way, because you receive all the columns and after your filter the columns in a next step.
If you use OData with ... /XRMServices/2011/OrganizationData.svc/AccountSet?$select=AccountId,Name you recived only 2 columns and it is more faster.
The point it is that OrganizationData it is a deprecated solution for the future...
Why Power Bi not apply correctly the API URL query?
Thanks
Is there still no solution for this? - Because of this you are pulling much more data in than required. For small databases this is not an issue, but when you have millions of records ...
In the query editor, select the columns you want and remove other columns.
Yes, I know, but the query returns a few hunderd columns.
It ieasier to write something like "field1, field37, field44, field77, ...."
than havingto select the fields manually with the mouse.
grts
Frederik
Yes, I know, but the query returns a few hunderd columns.
It ieasier to write something like "field1, field37, field44, field77, ...."
than havingto select the fields manually with the mouse.
grts
Frederik
There is a "Choose columns" option in the drop down menu which allows you search and select specific columns. Makes life a little bit easier.
