Odata Feed problem with datetime parameter

[Fossgm]

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'

[mllopis]

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.

[Fossgm]

Thanks M. 

I tried your suggestion but got the same error. My workaround is a crappy 'convert datetime to string' but I'd prefer not to do that. Here is a link to the fiddler trace. I didn't see anything in there that jumped out. 

https://www.dropbox.com/s/4m3ve1ioafrbpuz/power%20bi%20for%20salesorder%20set.saz?dl=0