Forum Discussion
Odata V4 Error. Couldn't parse OData response result.
Hi MikeSmallwood,
Based on error message, it mentioned invalid 'collection' variable in your query.
I don't think you can't direct use Odata V3 query in Odata V4.(it may contains some update for using parameter/variable)
I'd like to suggest your refer to the V4 document to create new query for this and try again.
What’s New in OData Version 4.0
Regards,
Xiaoxin Sheng
Hi Anonymous
Thanks for the response. I've looked at the documentation and my syntax looks OK. I'm struggling to apply any filter context inside an OData.Feed function.
Example
Let
OdataFeed4 = "http://Meta-Ltp-Yoga.metaphorix.co.uk:7048/DynamicsNAV100/ODataV4/Company('CRONUS UK Ltd.')/PurchaseOrders?$filter=Type eq 'Item'",
Source = OData.Feed(OdataFeed4)
in
Source
The URL works fine in a browser.
Any further help would be much appreciated.
Hi MikeSmallwood,
I think you can try to use below formula, power query keywords are case sensitive, so you can't use 'Let' as start or the formula.
let OdataFeed4 = "http://Meta-Ltp-Yoga.metaphorix.co.uk:7048/DynamicsNAV100/ODataV4/Company('CRONUS UK Ltd.')/PurchaseOrders?$filter=Type eq 'Item'", Source = OData.Feed(OdataFeed4) in SourceRegards,
Xiaoxin Sheng
Hi Anonymous
'Let" was just a typo in my message. I am using 'let' in my query.
Just t be clear this works fine in a browser but not in thr OData.Feed function .
Regards,
Mike
Hi MikeSmallwood,
Based on your description, it sounds like credential related issue. I'd like to suggest you use inprivate mode to test in web browser or test on power bi desktop after clean up stored odata credentials and cache files.
Regards,
Xiaoxin Sheng