Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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
Hi @v-juanli-msft,
I don't have Power BI Pro account. so I could not create a support ticket.
Thanks,
Prakash Sagadevan
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |