Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

modified date differs between sharepoint and query

Hi,    When I want to open a sharepoint excel document in power Query (to make a link to Power BI), it states that the modified date is 6-4-2021 (june 4th). However, it is a live document, which is...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    5 years ago

    Hi Anonymous 

     

    You may refer to this article (Power Query: Connecting to Excel Workbooks in SharePoint Online) about how to connect to an Excel workbook stored in Sharepoint Online. Make sure your Excel file in Sharepoint Online is updated successfully. If you are using Power BI Desktop, you need to click Refresh icon to import the latest data from this Excel file into the report. If the report has been published to service, it will detect the file changes in Sharepoint Online and update the data automatically.

     

    Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.

Watsky's avatar
Watsky
Solution Sage
5 years ago

Hey Anonymous welcome to the community!

 

To me this sounds like your OneDrive is not syncing do you have OneDrive connected and displayed in your taskbar? 

If not then that could be the issue. If you do have it in your taskbar when was the last time it was updated in OneDrive?


Did my answer(s) help you? Give it a kudos by clicking the Thumbs Up! ?
Did my post answer your question(s)? Mark my post as a solution. This will help others find the solution.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Watsky, 

     

    Thank you for your help! It took a few days to install my workspace accordingly but it still does not work the way I wished for. So I wonder, is syncing my computer with OneDrive necessary if I ask Power BI to make an online connection?