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 Team,
I m getting issue while importing data from sharepoint. issue is there is one Date column (ex- 10/08/2021) while importing in power bi it is showing 08/09/2021. Please help.
Data source:-
Power BI
Solved! Go to Solution.
Actually, you can add a custom column with this formula instead.
= Date.From(DateTimeZone.RemoveZone([DateTimeZoneColumn])
Or, you can add a transform column step on that column and update the function part in the formula bar to this
each Date.From(DateTimeZone.RemoveZone(_)
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
That is likely due to SharePoint date columns being UTC format, and it is getting converted to your local timezone. So that date is probably correct. If you do want to make them match, you can just keep the date component from that column. One way to do that is to first convert it to a text column, extract text before delimiter (use a space), and then convert it to a Date column.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I tried but getting error
Expression.Error: We cannot convert the value "8/9/2021 6:30:00 PM" to type DateTimeZone.
Details:
Value=8/9/2021 6:30:00 PM
Type=[Type]
Please help!
That value doesn't have the timezone component. Has the type already been changed at this point? Or is this the value from the source? Without the timezone component, I wouldn't expect you to see that behavior (date doesn't match value in SP list).
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
I am facing some issue its fixed in Power Bi query editor but once i published to power bi service again showing the previous date
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 |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |