Forum Discussion
Solved
Problem dealing with date type from different locations
Hello community, I am dealing with a Power BI than integrates data from different excels files hosted in a sharepoint. The issue comes from the date type, as sometimes Power BI captures it like "...
Thank you guys!
I ended up doing a super loooong cleaning, splitting by delimiters, and then joining again 🙂
Not the most elegant solution... but for now it works:)
Hey,
Power BI might get confused when reading data from excel if the date format in the same collumn differs (as you said that excel might have formats of "22-02-2031" and "2031-02-29", then the power bi does not know where the day/month/year is). Try changing the format in the source and if all dates have the same format then Power BI should not return error.