Public URLs for images on sharepoint

[Boja]

Hello,

I am trying to pull many photos (PNG) from online sharepoint folder and display them using Image Viewer visual on public Power BI report. The goal is to share report with external users without credentials.

I read several posts about this and followed instructions provided.

Sharepoint is set to allow sharing to authenticated external users and anonymous access links. 

To obtain public sharepoint URL they recomend copying the link and pasting into a browser. And then to use newly generated URL link:

https://intelligentvideosoftware.sharepoint.com/sites/DATA-IVS/Documents%20partages/Forms/AllItems.a...

However, i am importing more then 100 images and each one of them has different label and cid number. 

I have connected Power BI with the sharepoing folder using organizational credentials and i can see the list of images. But i dont know how to generate public link for all of them without manual pasting. I tried creating a link without cid number using conditiaonal column as follows:

URL link = 
"https://intelligentvideosoftware.sharepoint.com/sites/DATA-IVS/Documents%20partages/Forms/AllItems.aspx?id=%2Fsites%2FDATA-IVS%2FDocuments%20partages%2FDashboard%2F" 
& [ImgName] & 
"%2Epng&parent=%2Fsites%2FDATA-IVS%2FDocuments%20partages%2FDashboard&p=true"

However, the images are not visibale in incognito access.

How would you import bulk of sharepoing images with public url?

Thanks for brainstorming 🙂

[v-frfei-msft]

Hi @Boja ,

Please get the url of the image by this way.

[Boja]

Hi @v-frfei-msft ,

Thanks. However, it will be time consuming to do this for 100 photos (and more). Can you think of an automated way how to get this?