Forum Discussion
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
- v-juanli-msftCommunity Support
Hi Prakash1
I would recommend you to open a ticket to get help from MS senior engineer.
https://powerbi.microsoft.com/en-us/support/
Best Regards
Maggie
- Prakash1Regular Visitor
Hi v-juanli-msft,
Can you please help me how to open a ticket to get help from MS senior engineer?
The below link brings to the support page.
Thanks,
Prakash Sagadevan
- v-juanli-msftCommunity Support