Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
Hi @l_hendriks
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.
Hi @l_hendriks
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.
Hey @l_hendriks 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?
Proud to be a Super User!
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.