Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi,
One of the tables I have is imported from an excel sheet with a column in Date/Time format as shown below.
I need to convert it to Date in power Bi (not excel). The step I'm following are as follows:
1- Trim the colum and keeping the date only (ex. 14/01/2021)
2- Convert format from Text to Date
however, when I do this I get an error because of the regional settings (Locale for import) set on US Time.
Anyone can advise please?
Note: I tried to change the settings for the entire file from Options & Settings --> Options --> Regional Settings, and selected UK Time, but didn't success as after implementing the change I got the error message "loading blocked by failures with other queries" for all the other tables in the file.
I would be grarful if anyone can help.
Solved! Go to Solution.
right-click on the column, pick 'change type'-> using locale. I can't remember if you need to pick English(uk) or English(u.s.) but one of them will work
@OmarSaleh
As pointed out by @HotChilli , Choose English (United Kingdom)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @OmarSaleh - try conversion using locale.
= Table.TransformColumnTypes(Source, {{"Column1", type text}}, "en-NZ")
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! |
Just found it by right clicking on the column --> change type instead of using the tools bar. Thank you @KNP!
right-click on the column, pick 'change type'-> using locale. I can't remember if you need to pick English(uk) or English(u.s.) but one of them will work
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
36 |