Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
frederik
Advocate I
Advocate I

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

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
JorgeGO
New Member

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

Greg_Deckler
Super User
Super User

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


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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.

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.