Forum Discussion

AngusLin's avatar
AngusLin
New Member
7 years ago

Data in share point online does not align in power query

I am able to get data of share point online in power query successfully. However, I find out there are some data doesn't be align.

For example, one item had been modified on July 8th. The date of modified is correct. But some date in other columns are no align with share point online currently.

Does someone know the probably root causes?

Need Help

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi AngusLin ,

     

    Based on my test, I cannot reproduce your issue here using Power BI desktop Version: 2.72.5556.321 64-bit (August 2019). Could you please refersh the data to check again or you can update your Power bi desktop to the latest one to have a try. If the issue still occur, I recommend you to create a support ticket for help if you are a pro user.
     
    https://powerbi.microsoft.com/en-us/support/

     

     

    • AngusLin's avatar
      AngusLin
      New Member
      7 years ago

      Hi v-frfei-msft ,

       

      Thank you for your reply. Currently, the latest version of power bi desktop on web is 2.71.5523.941. I would wait for next version to verify this issue.

      Besides, the data of my power query is stiil inconsistant with my share point online list even I get data again.

      • AngusLin's avatar
        AngusLin
        New Member
        7 years ago

        Hi v-frfei-msft ,

         

        I could figure out the date & time of power query is inconsistant with share point online.

        It seems to the different time zone causes this issue. Do you know power query would get which time zone's data of share point online? I would apprecriate your assistance!