How to load an image stored in a sharepoint from its URL stored in an excel table?

[Anonymous]

Hi everyone,

I did a lot of research about how to import an image from a sharepoint, but my problem is a bit different:

I need to store the URL of the image from the sharepoint inside an excel file, in a dedicated table. This is the excel file I import in Power Bi to create my dashboard. The issue is I get an error saying "the image could not be loaded".

What did I do ?

I went to "table tools" in Power Bi, I set the category on "Image URL", then I added the cloudscope visual, and I dragged and dropped the image URL row in the dedicated spot.

Hope someone can bring me some advice on that.

Thanks for your time

[christinepayton]

Is your image url valid? Like if you go to it in a browser, does it load? It shouldn't matter what source your image url comes from as long as it's a valid url. 

Note that the images that are stored in SharePoint Online don't actually load in the desktop editor in my experience - you have to publish them to a workspace and view them in the web app to see them. My guess is it needs a browser token or something to handle the authentication. 

[Anonymous]

Hi!

Thanks for the reply.

So I checked and the URL is valid, the image appears when I copy paste the URL in the browser. I have to check if this is what you brought up: I have to publish it to view it. I'll try that and I'll tell you if that was the issue

[Anonymous]

Any idea?