Data mismatch issue.

Question

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&nbsp;'2020-03-31 23:59:59'&nbsp;Our Power BI data center is in California (GMT-7), the source system is Service Now whos data center is in&nbsp;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.&nbsp;&nbsp;

amitchandak · Answer

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

pragati11 · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;Check this link if it helps:https://community.powerbi.com/t5/Desktop/Handling-TimeZone-Conversions/td-p/568633&nbsp;Thanks,Pragati

anonymous · Answer

Thanks Amit &amp; 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.

v-kelly-msft · Answer

Hi &nbsp;Anonymous ,
&nbsp;
Have you tried to expand the time line selected in the query from ODBC to check whether it's a time zone issue?
&nbsp;
&nbsp;Best Regards,Kelly
Did I answer your question? Mark my post as a solution!

Forum Discussion

Data mismatch issue.

4 Replies

Related content

Type Mismatch

Sales and Stock Data Value mismatch issue

Unusual Data Mismatch

Data limit Issues

Data Upload Issue