Forum Discussion

Prakash1's avatar
Prakash1
Regular Visitor
8 years ago

OData.feed Implementation 2.0 does not work for $expand Query

New OData parser (Implementation="2.0") ignores the filter/expand restrictions.

 

The new OData feed implementation in PowerBI (Excel in production, after the last update) doesn’t filter/expand the results using $expand system query.

 

 Example:

 

1. Problem of implementation="2.0"

 

Query:
-------

let
    Source = OData.Feed("http://localhost:8080/odata/skills", null, [Implementation="2.0"]),
    #"Expanded skillcluster" = Table.ExpandRecordColumn(Source, "skillcluster", {"id", "label", "skillclusterfamily"}, {"skillcluster.id", "skillcluster.label", "skillcluster.skillclusterfamily"})
in
    #"Expanded skillcluster"
	

Background Query sends to server:
----------------
http://localhost:8080/odata/skills(2)/skillcluster

 

Screen Shot of the fiddler:

-------------------------------

 

 

 

After removed the [Implementation="2.0"] section in OData.Feed

 

Query:
-------

let
    Source = OData.Feed("http://localhost:8080/odata/skills", null),
    #"Expanded skillcluster" = Table.ExpandRecordColumn(Source, "skillcluster", {"id", "label", "skillclusterfamily"}, {"skillcluster.id", "skillcluster.label", "skillcluster.skillclusterfamily"})
in
    #"Expanded skillcluster"

Background Query send to server:
----------------
/odata/skills?$expand=skillcluster(%24select%3Did%2Clabel)&$top=1000

 

Screen Shot of the fiddler:

 

Can you please let us know is this bug in Power BI or guide me the right steps?

 

Thanks

Prakash Sagadevan

4 Replies