Forum Discussion

Fossgm's avatar
Fossgm
Frequent Visitor
11 years ago

Odata Feed problem with datetime parameter

Hello Power BI Community, 

 

I'm new to the Power BI toolset and perhaps am making a rookie error. 

 

I'm trying to access an oData feed from my backend SAP system. I'm using URL :

 

HTTP://<hostname>:<port>/sap/opu/odata/sap/ZEXAMPLE6_SRV/SalesOrderSet?$filter=CustomerNumber eq '0000023710' and SalesOrganization eq '1000' and DocumentDate eq datetime'2015-08-03T00:00'

 

This URL works both in my SAP system Gateway test and in both IE and Chrome. However, in Power BI it throws a '(400) Bad Request, no data found' error. When I make a parm change to call by material instead of by datetime it works (see URL below). It also works in just the regular excel 'Get External Data' -> 'From Other Sources' -> 'From OData Data Feed'... which seem kind of odd and doesn't work for me because I want to use Power Query to normalize my data. My only conclusion is that Power BI is doing something proactive with my datetime field to correct it or I don't know some rule around datetime for oData in Power BI specifically. Any insight would be so very greatly appreciated. 

 

-Greg

 

HTTP://<hostname>:<port>/sap/opu/odata/sap/ZEXAMPLE6_SRV/SalesOrderSet?$filter=CustomerNumber eq '0000023710' and SalesOrganization eq '1000' and Material eq '0245-0041-11'

Need Help

2 Replies

  • mllopis's avatar
    mllopis
    Community Admin
    10 years ago

    Hi Fossgm,

     

    Would you be able to provide a Fiddler trace so we can investigate further? Also, could you try changing your query to use a call to OData.Feed(<Your URL>, null, [ODataVersion = 3]) and see if that makes any difference in the result?

     

    Thanks,
    M.