I am trying to extract the records from Oracle Database. I link the data model through external Oracle source.
The below query which is running perfectly through TOAD, i used in the data model. The output in power pivot grid not same as TOAD output.

Please Login or Register  to view this content.
In Toad, i can see the records effective from 1st Aug 2016, but in Power Pivot execute the query but the output does not show Aug 2016 records.
Can someone guide be to correct the above query to get all records where effective date is in Aug 2016.

Thanking you in anticipation.