Forum Discussion

MikeSmallwood's avatar
MikeSmallwood
Frequent Visitor
8 years ago

Odata V4 Error. Couldn't parse OData response result.

I'm using OData V3 and V4 for retrieving data in Power BI Desktop.   I get the following error when trying to execute my Query from Power BI Desktop.   "DataSource.Error: We couldn't parse OData ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

MikeSmallwood's avatar
MikeSmallwood
Frequent Visitor
8 years ago

Hi Anonymous,

 

The credentials are fine and the URL string works fine in a browser.

 

The URL string also works fine in the OData.Feed function under V3 (i.e. if I replace "ODataV4" with just "OData" in the URL).

 

There must an issue with the syntax of the string for OData V4 or an issue with Power BI Desktop.

 

Can you confirm via an example that you know works?

 

Kins regards,

        

Mike

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi MikeSmallwood,

     

    Maybe you can try to add page parameter into request url or direct use odata as the parameter:

     

    let
    OdataFeed4 = "http://Meta-Ltp-Yoga.metaphorix.co.uk:7048/DynamicsNAV100/ODataV4/Company('CRONUS UK Ltd.')/Page/PurchaseOrders?$filter=Type eq 'Item'",
    Source = OData.Feed(OdataFeed4)
in
    Source

     

    >>The URL string also works fine in the OData.Feed function under V3 (i.e. if I replace "ODataV4" with just "OData" in the URL).

    BTW, I double check on newest version official document and not found v4/v3 exist in that query string.

    Using Filter Expressions in OData URIs

     

    Notice: if your data contains any privacy data, please do mask sensitive data before sharing.

     

    Regards,

    Xiaoxin Sheng

    • MikeSmallwood's avatar
      MikeSmallwood
      Frequent Visitor
      8 years ago

      Hi Anonymous,

       

      When NAV 2016 introduced OData V4 support they provided a seperate URL for the V4 published web service. The only difference is the "V4" on the end of OData in the URL (see below).

       

      The URL works in a browser with and without the "V4" but presents different results based on the V4 protocol (see below). The OData.Feed function will only work without the "V4".      

       

      I need to understand how to use OData.Feed to get the V4 output. Is there anyone who can point me in the right direction?

       

      Kind regards,

       

      Mike       

             

       

      let
      Source = OData.Feed("http://Meta-Ltp-Yoga.metaphorix.co.uk:7048/DynamicsNAV100/ODataV4/Company('CRONUS%20UK%20Ltd.')/PurchaseOrders?$select=Buy_from_Vendor_No, Document_No&$filter=Buy_from_Vendor_No eq '30000'")
      in
      Source

       

      V3 URL Result 

       

      V4 URL Result