Images URL changes

[Anonymous]

Hi everyone, today im having this issue with my links from sharepoint.

They used to be in this way:

.com/_api/v2.1/drives/b!CT3wUVZsKEKCSHHEQV9W5RC4EnZ2lF1Eg7LVhPDQUPvnuKnsKRMdSIp3SE_UV8Jm/items/01UIMW2VOFRC4TLR3VGNFZYDPUP3M57IHU/thumbnails/0/c3000x2000/content?prefer=noredirect%2Cclosestavailablesize&cb=1&s=L3NpdGVzL1N1cmZhY2VQcm9qZWN0L0xpc3RzL1Bvc3RlRHxJenFWQlR

And now theyre like this:

.com/sites/SurfaceProject/_api/v2.1/sites('51f03ad2323109-6c56-4228-8248-71c4415f56e5,7612b810-9476-445d-83b2-d584f0d050fb')/lists('99baead7-15bd-402a-acae-2296c74b6202')/items('173')/attachments('Reserved_ImageAttachment_%5B6%5D_%5BDerVBT%5D%5B36%5D_%5B6270b30b-46ee-4579-a539-e5dc1f52d69a%5D%5B1%5D_%5B3%5D.jpeg')/thumbnails/0/c3000x2000/content?prefer=noredirect%2Cclosestavailablesize

My problem here is when i want to use them in powerBI.

Im not longer reciving them, they appear as NULL in powerQuery.

Someone else wi

[JaSchu]

Hi Jesus9709,

I can confirm this problem. I have running different PowerAutomate "scripts" and no one is working because of the new API path. Completely out of the sudden Microsoft is changing paths in SharePoint?! Great idea...

[Anonymous]

So we need to wait for some patch or update 😕

[JaSchu]

I don`t think that waiting will help us. What I have read trough the internet is that users experienced that kind of change troughout this year. I think Microsoft is rolling out this kind of new "feature" to all of us. It`s not a bug, it`s a feature 😉 In my case I could help me in PowerAutomate with "get attachments" and "create file". So PowerAutomate is "crawling" trough the specific line in the SharePoint list and after that it is creating the found file in an additional folder on the SharePoint.

[JaSchu]

I hope so! I was able to see each picture in the subfolder on the SharePoint site called websiteobjects/lists. Now newly added pictures won`t appear here.

[JaSchu]

I mean site assets like here: https://lists.handsontek.net/microsoft-lists-images-stored-2024/

[Anonymous]

Hi @Anonymous 

The API path and parameters section of the new link seems to have changed compared to the old link. It may be necessary to update your Power Query code to accommodate the format of the new link. Please share your code.

Also, check to update your data source settings as well as SharePoint access permission.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

And here is another example:

Old links:

New links: