Forum Discussion

Russ Hancock's avatar
Russ Hancock
Copper Contributor
May 16, 2025

PowerQuery not reflecting changes to filenames in Sharepoint Library

Hi All.

I've got a simple SPO library with files that I need to query within Excel via PowerQuery, I'm using the Query Type SharePoint List rather than SharePoint Folder because I need other metadata from the library.

So far so good, query works great, now the issue, IF I change the filename in the library it does not update in the PowerQuery results.

  • New files will appear OK,
  • other metadata changes appear
  • Version numbers update.

Simply the filename will not show the change, Cleared the PowerQuery Cache, that didn't work.

File in Library

Result in PowerQuery

If I create a new Query in a fresh Spreadsheet, same result? 

 

Any suggestions greatly appreciated.

Cheers 

Russ

BI & Data Analysis
excel
power bi

2 Replies

Sort By
  • Kidd_Ip's avatar
    Kidd_Ip
    MVP
    May 18, 2025

    See whether below can help:

     

    • Check SharePoint Metadata Refresh:

    Try manually refreshing the query and ensuring metadata updates are enabled.

    • Use SharePoint Folder Instead:

    While you prefer SharePoint List for metadata, switching to SharePoint Folder might help capture filename changes more reliably.

    • Modify Query Steps:

    Ensure filename not locking in old names. Try adding a step to dynamically pull the latest filenames.

    • Russ Hancock's avatar
      Russ Hancock
      Copper Contributor
      May 19, 2025

      Thanks for responding... on the points..

      1. I've recreated simple queries from scratch, in new spreadsheets..
      2. Sharepoint Folder is better, HOWEVER, there is nothing in the Folder query that means I can connect the data to the Sharepoint List query, i.e. it doesn't return any other metadata, namely ID would help!!
      3. Can you explain this more please?

Resources