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,

 

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
    Source

 

Regards,

Xiaoxin Sheng

MikeSmallwood's avatar
MikeSmallwood
Frequent Visitor
8 years ago

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     

  • 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