Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

Date Format from SharePoint List to Power BI

Hello I have a SharePoint List with following settings in the Date field - Date only and Display format (Standard)  - The date is dd.mm.yyyy This list is imported into Power BI Power BI understa...
Need Help
Tips and Tricks
  • Heinrich's avatar
    Heinrich
    3 years ago

    Hello
    Thank you.
    I was able to resolve the case.
    I had to change the list settings in SharePoint.
    The locale had to be set in the SharePoint List.
    Wish you all the best.
    Thank you for your support
    Heinrich

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
3 years ago

Heinrich , That formula which I've given is in DAX Calculated column. Attaching screen shot for your reference

 

 

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago

Thank you for your effort. It worked.
I tried but still a get the wrong data.
Power BI understands SharePoint list as mm.dd.yyyy instead of dd.mm.yyyy
Regards
Heinrich

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    3 years ago

    Heinrich Could you please only share the Date column into excel? I'll try it at my end.