Welcome to the wonderful and annoying world of dealing with timezones in Power BI.
If 14 returns what you want, I would use that.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
I often have to use 14 if data is missing from 15.
No problems as far as I'm aware.
The other date related issues can be resolved by editing the site settings if you are the SharePoint admin.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
My Sharepoint site settings are
My Windows language settings
My Power Bi Settings
I have made sure that everywhere i am using australia, But still when I import the data with API version 15, The dates are reduced by 11 hours and present a prior day.
Welcome to the wonderful and annoying world of dealing with timezones in Power BI.
If 14 returns what you want, I would use that.
| Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
| If you found this post helpful, please give Kudos. It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen. If you find my signature vaguely amusing, please give Kudos. | Proud to be a Super User! |
Im using API =14 for 6 months and worked great until recently all my connection become error as below
Been tring to solve this for days, but nothing works. Of course using API =15 works but then Ih= hav to repeat the steps of transforming the data gain
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
