Forum Discussion

sky54000's avatar
sky54000
Frequent Visitor
7 years ago

Date problem

Hello everyone,   I just realized that I have a problem from the dates imported from my Sharepoint system into PowerBi software. The dates are modified by PowerBi without any actions on my side. Po...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi sky54000,

 

By my tests with connecting the data with SharePoint Folder in Power BI Desktop, everything works as expected.

 

How do you conncet your data in SharePoint? List or Folder?

 

In addition, as HotChilli mentioned, this issue may caused by time zone, please check your time zone for power bi and the time zone for SharePoint is the same?

 

Best Regards,

Cherry

  • sky54000's avatar
    sky54000
    Frequent Visitor
    7 years ago

    Hi v-piga-msft,

     

    I connect my data in Sharepoint using the List connector.

     

    How do I check the timezone of PowerBI ? I didn't found any parameters for the timezone in PowerBI software.

     

    Sincerely yours,

    Robin.

     

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      7 years ago

      Hi sky54000,

       

      Based on this blog, we could use Now() to get the timezone.

       

      Best Regards,

      Cherry