Hey Fernan thanks for the video. I appreciate you explained it in a very clear and easy to understand. One thing I think worth point out is that for the Time in Philippines column, as soon as you change its type to Date Time, it shows your local time instead of the real time in the Philippines. I see that happen in my report as well. Any chance you can revisit this video and update new tricks for this please?
I was able to use this video to work for me in Australia. th-cam.com/video/xOj7KNqe_cI/w-d-xo.html Instead of using 1 and 2 in the time shift it was 10 and 11.
Awesome! Very clear! Is there a way to make it into a function? I have a column that contains date/time/timezone and I want to add a new column that would each row to a different timezone?
Dear Fernan, Thank you for your consistently interesting and very useful content. It's always a pleasure to watch your videos. Today I have a question regarding the number format in the service area. I create my reports in Germany in the desktop version. Number format is decimal comma and thousand point. When I publish the report in the service area, the number format changes to decimal points and thousand commas. Do you have an idea how I can also display the original number format in the service? Thank you for your effort and good luck with your posts. Best regards Andrew
Great Video, thank you, Fernan! Q - if I get my data from another source, SnowFlake in my example - then it converts in Power BI to where the PBI data is stored at?
formatDateTime(parseDateTime(split(convertTimeZone(triggerOutputs()?['body/receivedDateTime'],'UTC','Singapore Standard Time'), '+')[0]), 'M/d/yyyy h:mm tt', 'en-US') what's the difference from switch timezone or it can be used together? Newbie here.
Hey Fernan thanks for the video. I appreciate you explained it in a very clear and easy to understand. One thing I think worth point out is that for the Time in Philippines column, as soon as you change its type to Date Time, it shows your local time instead of the real time in the Philippines. I see that happen in my report as well.
Any chance you can revisit this video and update new tricks for this please?
same thing I just noticed when tried to follow these steps.
By far the best explanation on TH-cam
Still doesn't seem to work once published to the service unfortunately :(
I was able to use this video to work for me in Australia. th-cam.com/video/xOj7KNqe_cI/w-d-xo.html
Instead of using 1 and 2 in the time shift it was 10 and 11.
When converted to datetime this doesnt work again it get back to local time and in power bi service also showing wrong time
Wooooww, This video saved me! Thanks for sharing :)
Awesome! Very clear! Is there a way to make it into a function? I have a column that contains date/time/timezone and I want to add a new column that would each row to a different timezone?
Dear Fernan, Thank you for your consistently interesting and very useful content. It's always a pleasure to watch your videos. Today I have a question regarding the number format in the service area. I create my reports in Germany in the desktop version. Number format is decimal comma and thousand point. When I publish the report in the service area, the number format changes to decimal points and thousand commas. Do you have an idea how I can also display the original number format in the service? Thank you for your effort and good luck with your posts. Best regards Andrew
Great Video, thank you, Fernan!
Q - if I get my data from another source, SnowFlake in my example - then it converts in Power BI to where the PBI data is stored at?
this doesnt work as if you note @ 08:42 when he converts into Date/Time format. it changes to local date and time.
👍❤
formatDateTime(parseDateTime(split(convertTimeZone(triggerOutputs()?['body/receivedDateTime'],'UTC','Singapore Standard Time'), '+')[0]), 'M/d/yyyy h:mm tt', 'en-US')
what's the difference from switch timezone or it can be used together? Newbie here.