modified date differs between sharepoint and query

[Anonymous]

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 modified as we speak by either me or my colleagues. So, the modified date should be today (in this case 6-9-2021 (june 9th) and not 6-4-2021. How can I ensure that the connected data of sharepoint is the most recent dataset?

[v-jingzhang · Accepted solution]

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]

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]

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?