Forum Discussion

frederik's avatar
frederik
Frequent Visitor
9 years ago
Solved

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://tenan...
Need Help
  • frederik's avatar
    frederik
    9 years ago

    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.

     

JorgeGO's avatar
JorgeGO
New Member
8 years ago

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

wlknsn's avatar
wlknsn
Helper I
8 years ago

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 ...