Is this a Power BI thing, or a sharepoint thing?

[Anonymous]

I have created a dashboard via desktop, published it, embedded it into Sharepoint.

When I check it over to ensure everything is working correctly, I can see that there are a couple of issues with a data card that includes a date and time

Desktop

Sharepoint

Firstly, the date format has been changed from DD/MM/YYYY to MM/DD/YYYY and second; the timestamp has not encorporated daylight saving time, meaning that it is 1hr behind the true refresh time.

It will be really frustrating explaining to senior leaders that they need to trust me that its been refreshed, even though it shows that its an hour behind!

Can anyone help with this?

Thanks,

Chris

[v-alq-msft]

Hi, @Anonymous 

Power BI service is based on the UTC time. I'd like to suggest you refer the following links to see if they help.

Solving DAX Time Zone Issue in Power BI

Daylight Saving Time And Time Zones In M

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[edhans]

I don't know about the format, other than perhaps your computer/Power BI desktop is in a different region format than your SharePoint server. Might need to consult with your SharePoint admin on that.

On DST, you have to have a DST table to determine if you are in a DST time period or not, then add 1 (yes) or 0 (no) to the refresh time. ALl refresh times are based on UTC with no DST. You'd use DateTimeZone.SwitchZone(DateTimeZone.LocalNow(), -x + varDST) where X is your timezone offset, and varDST is the 1 or 0.

I have a DST table with two columns - DSTStart, and DSTEnd. I then filter this table to be today is >= DSTStart and today is <= DSTEnd then count the rows. It returns 1 or 0 to that query. I could call that query varDST and use it in formulas as above.

[mwegener]

Hi @Anonymous ,

this is due to the Power BI Service, which runs in UTC time.