Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm trying to import the Date field from SharePoint Online to Power BI .I could see the Date field is one day less than the value displayed in SharePoint. Is there a way to sort this issue ?
I think it's somthing to do with Day light Saving. I am worried to include a custom column in Power BI as it would have advers effect during the Day light saving. I am based out of UK region.
Your help is really appreciated. Since I am new to Power BI reports would be good, if you could help with the steps in details.
Thanks!
I was able to fix this issue. By converting DateTime field to the corresponding TimeZone. Thanks
Please change the ApiVersion to 14 in the Advanced Editor of your query.
If the above step doesn't work, please add a custom column to convert date to your time zone following the guide in the similar blogs below.
http://radacad.com/solving-dax-time-zone-issue-in-power-bi
https://www.c5insight.com/Resources/Blog/tabid/88/entryid/121/gotchas-when-using-power-query-to-retr...
Regards,
Lydia
That sounds odd. You can edit your query to add days or time or whatever, but that sounds weird.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.