Forum Discussion

Victormar's avatar
Victormar
Icon for Helper V rankHelper V
2 years ago
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 "...
Need Help
Tutorial Requests
  • Victormar's avatar
    Victormar
    2 years ago

    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:)

moncx's avatar
moncx
Icon for Resolver II rankResolver II
2 years ago

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.