Forum Discussion
SharePoint.Files() stops picking up new files in personal OneDrive — breaks every Power BI report us
Problem
Since Monday, July 20, 2026, newly added files stop being picked up by every Power BI report using this same connection pattern (separate .pbix files for cost, sales, target compliance, warehouse outflows, HR — all pointed at different subfolders of the same OneDrive).
What's already been ruled out:
- OneDrive storage quota: account has 1 TB available, only ~20 GB used. Nowhere near the limit.
- Sync status: confirmed fully synced, no error icons in the OneDrive client.
- Folder path: confirmed via breadcrumb that the file sits exactly in Documents/xxxxx/xxxxxx/xxxxxx/, no subfolder drift.
- SharePoint search index: the file does show up in SharePoint/OneDrive's native web search (uploaded same day).
- Renaming an existing (already-loaded) file works fine — Power BI picks up the rename and updated content immediately. The problem is specific to brand-new files.
The key detail: checking the "Source" step in the Power Query Editor (i.e., the raw output of SharePoint.Files(), before any filters are applied), the new file does not appear there either — even though it does appear in the SharePoint/OneDrive web search UI.
7 Replies
- Zanqueta
Super User
Hi , the issue doesn't seem to be in your filters because the new files are missing from the very first SharePoint.Files() step. That means Power BI isn't seeing those files at all.
Since existing files and renames are detected correctly, I would try clearing the Power BI cache and refreshing the SharePoint credentials first. If the issue persists, my suggestion is to test SharePoint.Contents() instead of SharePoint.Files(), as there have been reports of SharePoint.Files() not picking up newly added files due to metadata caching behaviour, while SharePoint.Contents() returns the files correctly.Please, check this solved topic: 
v-abhinavmuCommunity Support
Hi ancito,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Zanqueta & calerof for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
- v-abhinavmu
Hi ancito,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you Hi everyone, I just wanted to let you know that, for now, the feature you mentioned is showing me the following information:
Appfiles
Documents
FormTemplates
ListTemplateGallery
MasterPageGallery
SolutionGallery
StyleLibrary
ThemeGallery
WebPartGalleryI'm working on verifying whether I can access the documents and see if it shows me the corresponding files.
Thank you for any possible solutions to this problem.😃- v-abhinavmu
Hi,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to calerof for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
