Change timezone and datatype

(0) Share

Report

Posted on by Soumya

Hi,

1.I have flow which is connected to sharepoint and power bi.

I am receiving wrong timezone in Power bi which is 1 hour ahead of actual time received at share point database.

Question: how to change timezone in Power bi?

2.Here received time format in Power bi is 12 hour format I Need time format in 24 hours for date/time column which is received from sharepoint to power bi

Question: how to change date/time column to 24 hours in flow?

3.How to Change decimal value to whole number in flow?

Thanks in Advance,

Soumya

Categories:

Using connectors

All responses (3)

Answers (0)

Sort by

xrm 32 on at

Like
a
(0)

Report
Copy link

Link copied!

Try this

https://sharepointlibrarian.com/2017/10/29/convert-time-zones-in-power-bi-using-dax/

For changing DateTime use ConvertTimeZone function.

convertTimeZone(timestamp:string, sourceTimeZone:string,destinationTimeZone:string, format?:string)
Soumya 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @xrm,
Thanks for your Response, The link which you send is working in Desktop I need this to be worked in power bi service. I am already having date/time column in sharepoint. When I receive the same data in Power Bi, date/time column receives 1 hour ahead of actual date/time in sharepoint.
Thanks in Advance,
Soumya
v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Soumya,

Could you share the specific details of your Flow configuration?

Depending on the actual creation of your Flow, we may be able to give more targeted advice.

Q1：

I have not found a place to set TimeZone in the Power BI portal, you could try to set it directly in 0365 setting.

You could also use addHours() function in the corresponding Date field to reduce the time difference when configuring Flow action.

Q2：

I want to know where you want to change the time format display time to 24 Hours format. As far as I know, the format of the time displayed in Flow is 24 Hours.

This may also be related to your settings. For Flow and Power BI, you could refer to the steps for setting TimeZone in Q1 and select 24 Hours in the Time Format option.

For Flow, you could also use the Expression-formatDateTime() function to modify the time format.

Q3：

Could you give an example of how you will need to convert data types?

What I understand is to remove the decimal point after the decimal value, leaving only the previous integer.

If so, you could refer to this method:

Expression：

int(first(split(string(outputs('Compose')),'.')))

Best Regards,

Barry