Data mismatch issue.

[Anonymous]

Hi All,

We are facing data issue due to Time zone (I suspect). I am using native query (via ODBC) select val from table where Date between '2020-03-01 00:00:00' and '2020-03-31 23:59:59' 

Our Power BI data center is in California (GMT-7), the source system is Service Now whos data center is in Washington DC (GMT - 4).

When I am trying to fetch data (from India GMT+5.30), e.g. for March 1 to March 31, I am getting less records (records till 30 March) I guess its beacause of time zone issue.

Anyone has any work around for the same.

Note that - we have to use date filter inside native query to avoid time out issue.

[v-kelly-msft]

Hi  @Anonymous ,

Have you tried to expand the time line selected in the query from ODBC to check whether it's a time zone issue?

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Pragati11]

Hi @Anonymous ,

Check this link if it helps:

https://community.powerbi.com/t5/Desktop/Handling-TimeZone-Conversions/td-p/568633

Thanks,

Pragati

[amitchandak]

@Anonymous , refer if these can help

https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337

https://www.youtube.com/watch?v=M1zquwmpnZE

[Anonymous]

Thanks Amit & Pragati for your replies,

Actaully all the posts are focusing on date conversion after getting data inside power query however in my case we need to have date conversion before data being loaded into Power query; I have to use it in where cluase of native query.