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

[Prakash1]

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

[v-juanli-msft]

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

[Prakash1]

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-msft]

Hi @Prakash1

Scroll down to see "still having issues->CREATE SUPPORT TICKET"

Best Regards

Maggie

[Prakash1]

Hi @v-juanli-msft,

I don't have Power BI Pro account. so I could not create a support ticket.

Thanks,

Prakash Sagadevan