Hi,

I have some queries connected to a SharePoint Site - the queries are purely to extract metadata on the Site itself (permissions, etc.) - I’m not trying to connect to specific files on the Site.

Recently, we completed a data cleansing operation and updated a lot of the permissions and other metadata on the Site but for some reason the updates aren’t pulling through to Power Query. Some of the renamed User Groups are appearing when I refresh the queries and others aren’t appearing - I have checked everything on the SharePoint side and it’s correct so I can’t figure out why the updates aren’t pulling through to PQ. I’ve cleared the cache in Power Query and I’ve tried using different API Versions for the SharePoint connection but I cannot for the life of me figure out the problem.

Does anybody have any idea why this is happening?

Many Thanks,

Jack