The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi,
I have multiple date columns coming from SP as "Fri Nov 19 2021 19:31:44 GMT+0530 (India Standard Time)" this format and while converting into date, it is showing error. Any idea how to convert it ?
Thanks in advance ,
Switto
Solved! Go to Solution.
Hi All, We did some research and tried the option "Extract" and than "Range" in Add column in Power query as the data is same in all rows and worked fine.
@Switto , Follow the below steps:
Step 1: Go to Power Query Editor
Step 2: Select your Date column and right click on it and select Split column
Step 3: Enter 15 like below and choose the first option
Step 4: You'll get the answer in the first column like this:
Hi All, We did some research and tried the option "Extract" and than "Range" in Add column in Power query as the data is same in all rows and worked fine.
Hi @Switto .
If it's data format is text, then you can't directly convert it to a date format.
Which mode did you use to import the file into your Power BI desktop?
You will need to change your format from there only.
Regards,
Sanket
If this post helps you give it a 👍 and if it solved your issue consider Accept it as the solution.
@SanketBhagwat , Thanks for the quick reply. As it is an online ShrePoint list, I have connected data through SP Online list option.
Okay.
Then I would advise you to change its format in the Share Point list.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
78 | |
70 | |
52 | |
50 |
User | Count |
---|---|
123 | |
119 | |
76 | |
64 | |
60 |