Forum Discussion
MYSQL connection Date problem
I guys,
I have a power BI report which one of it's source is a MYSQL Database.
The query has a field "created_at" which is a datetime field.
When iam refreshing the report sometimes power bi subtracts one hour to that field, sometimes it gave the correct value.
Have you guys face someting similar to this ?
Any problem with the connector ?
Iam running out of ideas, please help.
Anonymous it was a problem regarding the source database :(
The Connector is working fine :) Thanks for the concern.
5 Replies
Anonymous it was a problem regarding the source database :(
The Connector is working fine :) Thanks for the concern.
Hi Anonymous,
There is my M script on Power BI:
let
Source = MySQL.Database("xxxxxx", "xxxxxx", [ReturnSingleDatabase=true, Query="SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;#(lf)SELECT SO.id #(tab)#(tab) #(tab) #(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)as sale_id,#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(lf)#(tab) SO.identification #(tab) #(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)as sale,#(lf)#(tab) SO.created_at #(tab) #(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)#(tab)as date#(lf)FROM orders SO#(lf)WHERE 1=1#(lf)AND SO.state_id in (2,4,5);#(lf)SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ;#(lf)"]),in
#"Source"And then when i refresh the query several times on the query editor it has that strange behavior ( sometimes it has the correct result, others it retrieve date with one hour early). Same behavior its happening outside query editor.
