cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
frederik Frequent Visitor
Frequent Visitor

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.

 

crm.PNG 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
frederik Frequent Visitor
Frequent Visitor

Re: Dynamics 365 - Odata return only selected 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.

 

View solution in original post

6 REPLIES 6
Super User IV
Super User IV

Re: Dynamics 365 - Odata return only selected columns

In the query editor, select the columns you want and remove other columns.


I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

frederik Frequent Visitor
Frequent Visitor

Re: Dynamics 365 - Odata return only selected 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

frederik Frequent Visitor
Frequent Visitor

Re: Dynamics 365 - Odata return only selected 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

frederik Frequent Visitor
Frequent Visitor

Re: Dynamics 365 - Odata return only selected 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.

 

View solution in original post

JorgeGO New Member
New Member

Re: Dynamics 365 - Odata return only selected columns

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 Regular Visitor
Regular Visitor

Re: Dynamics 365 - Odata return only selected columns

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

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors