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! | |
Helpful resources
Power BI Monthly Update - November 2023
Check out the November 2023 Power BI update to learn about new features.
Fabric Community News unified experience
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Exclusive opportunity for Women!
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
The largest Power BI and Fabric virtual conference
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.
