Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have seen many threads on this problem but nothing I have tried has worked.
I am trying a solution of adding one hour to the time in SharePoint before importing to Power BI. This gives the correct date but unfortunatelty Power BI imports it as text in this format:
2022-11-25T01:00:00Z
I have tried converting this data type to date or date and time but I get an error message saying it is not possible.
Does anyone know how I can get Power BI to import it as a date or convert it from text.
Thank you.
Phil
Solved! Go to Solution.
Hi @Hepworthnot ,
Have you tried to change type with using local?
Change the data type to date or date/time type, and then in the Locale, select the region where the date format you imported is the same. Below are sample input values for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Hepworthnot ,
Have you tried to change type with using local?
Change the data type to date or date/time type, and then in the Locale, select the region where the date format you imported is the same. Below are sample input values for your reference.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |