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

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

Sorry I did that but I don't think I did it right

1. = Table.AddColumn(#"Changed Type", "Test", each [Start Date])

2. = Table.TransformColumnTypes(#"Added Custom",{{"Test", type date}})

3. = FORMAT("MS Teams Enable Teams Federation"[Test],"DD.MM.YYYY")

This gives me an error. How can this be done
Regards
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.