Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

power bi changes date from source data

When I get data from SharePoint, or refresh the data, Power BI changes the dates that are downloaded from SharePoint.   For instance I have a column called "Period Start" which is always the first ...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous,

 

I'm afraid your issue may caused by the timezone.

 

You could have a reference of this similar thread and try the workaround which meet your scenario.

 

If you still need help, I need more details about your scenario. Which connector do you use in Power BI when get data from SharePoint? 

 

If it is convenient, please share some data sample which could reproduce your scenario so that I can have a test in my site.

 

Best  Regards,

Cherry

Anonymous's avatar
Anonymous
Not applicable
7 years ago

There appears to be an issue with the time zone and daylight saving and SharePoint. When I use an excel file for the source data, the dates are correct, but not from SharePoint.

 

I have set up SharePoint with the correct regional settings, but Power BI amends the dates when importing them.

 

I have included some sample data to show the issue. It can be found here:  https://www.dropbox.com/s/y75217g9al1mkoa/Example44.pbix?dl=0

 

For information the correct dates are shown in this table:

 

TitleInitiative NameStart DateOriginal End DateApproved End DateActual End Date
C0005101Project 129/01/201830/04/201831/07/20185/09/2018
C0008007Project 215/02/201820/12/201820/12/2018 
C0012001Project 314/05/201831/07/201831/07/2018 
C0021021Project 41/03/201831/12/201831/12/2018 
C0021022Project 51/05/201828/02/201928/02/2019 
C0021023Project 61/06/201828/02/201928/02/2019 
     

 

Thanks

Steve

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

    Hi Anonymous,

     

    By my tests with your data sample, I cannot reproduce your scenario.

     

    I created the SharePoint List with your data sample and get data with SharePoint list connector in Power BI, everything works as expected.

     

     

    Please check the timezone for your SharePoint and your Power BI.

     

    Best  Regards,

    Cherry

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Cherry

       

      I have checked both SharePoint and Power BI settings and they are correct. So I am a bit stuck, without resort to a power query solution. 

       

      Cheers

      Steve