Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

ruimonteiro

Odata feed with $select statement

Submitted by on ‎08-02-2017 06:11 AM

Hi,

 

Trying to get data from dynamics with an odata feed and selecting only one column at server.

The result includes all the columns from the source. 

 

Screenshot_1.png

 

 Any help would be appreciated.

 

Thanks in advance.

 

Rui

 

Status: Accepted
See more ideas labeled with:
5 Comments (5 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎08-03-2017 12:46 AM

@ruimonteiro

 

I’ve reported it internally to Power BI Team: CRI 43822176
I’ll post here once I get any update about it.

 

As a workaround, you can use the "Choose Columns" function to keep the column you want.

 

Odata feed with $select statement_1.jpg

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎08-03-2017 12:47 AM
Status changed to: Accepted
 
ruimonteiro
Regular Visitor
‎08-03-2017 01:34 AM

Hi Herbert,

Thank you for your quick response.

 

Yes, I'm using for now the workaround as you suggested, although this restriction is done on client side with unnecessary column data transfered (although, and as i could understand, the unnecessary columns are filled with null at server side).

 

Best Regards,

v-haibl-msft
Microsoft Employee
Microsoft Employee
‎08-03-2017 06:31 PM

@ruimonteiro

 

I’ve got response from the Product Team.

 

This is a known and longstanding issue which is being tracked. We're hoping to be able to address it before the end of the year but aren't making any promises.

 

Best Regards,
Herbert

AndrewMcQ
New Member
‎02-04-2020 04:30 AM

@v-haibl-msftcan we have an update on CRI 43822176 please?

Idea Statuses