My sharepoint list updated the date as US format mm/dd/yyyy. At power BI sycn sharepoint list items. the date show UK format dd/mm/yyyy. when I do the dashboard, I found out the data date record in Sharepoint is 9/7/2020 (mm/dd/yyyy) display the result show in July 9 2020.
This is date show in SP list. MM/DD/YYYY
in power BI table list:
at power dashboard, those record in Jul 2020 by right should be in Sep 2020. how to resolve the date covertion to US date in powerBI? FYI, currently in power BI, the financedatetime column as text.
Go to File --> Options and Settings --> Options --> Current File --> Regional Settings
and in the locale for import either choose UK or US.
I think it is UK in your case, if your underlying locale and how you want to see the the dates in the report is US, but I haven't completely understood. So try with both
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi @tracy2020 ,
I may not be fully understanding your problem correctly, but a common issue I've found with SharePoint and Power BI is when the region of the SharePoint library has not been correctly set. It often defaults to US.
In SharePoint, if you go to 'Settings' --> 'Site Information' --> 'View all site settings' --> 'Regional Settings'
you should be able to check/update if this is the issue.
| 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. |
Hi @tracy2020 ,
I may not be fully understanding your problem correctly, but a common issue I've found with SharePoint and Power BI is when the region of the SharePoint library has not been correctly set. It often defaults to US.
In SharePoint, if you go to 'Settings' --> 'Site Information' --> 'View all site settings' --> 'Regional Settings'
you should be able to check/update if this is the issue.
| 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. |
Go to File --> Options and Settings --> Options --> Current File --> Regional Settings
and in the locale for import either choose UK or US.
I think it is UK in your case, if your underlying locale and how you want to see the the dates in the report is US, but I haven't completely understood. So try with both
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Helpful resources
Power BI Monthly Update - August 2025
Check out the August 2025 Power BI update to learn about new features.
Fabric Community Update - August 2025
Find out what's new and trending in the Fabric community.
