Forum Discussion
Sharepoint file not updated
I wonder why you're using a Sharepoint folder connection when you are connecting to a single file only as shown in your query. That aside, are you able to see the missing rows in the query editor? What about in the preview prior to connecting to the worksheet itself?
If you don't see those lines, try adding InferSheetDimensions option to Excel.Workbook
Excel.Workbook(#"xxx xlsx_https://xxx sharepoint com/sites/xxx/Shared Documents/Customer team management/xxx/xxx/", [InferSheetDimensions = true])
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum.
Based on the previous discussion in the forum: Solved: Fetching data from sharepoint but it's not refresh... - Microsoft Fabric Community
what worked for them was to make sure that all users closed the file on their browsers, and then I refreshed in PowerBI and the changes updated.
Other than that try to
Go to File -> Options and Settings -> Options -> Data Load -> Clear Cache under Data Cache Management options.
Go to Transform Data > Data Source Settings -> Clear permissions for your SharePoint connections. Re-add the connection through get data or the Data Source settings and authenticate.
Please check the refresh status after clearing cache and re adding the connection details.
I hope this information helps. Please do let us know if you have any further queries.
Thank you