Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.