Forum Discussion

KarlOnEarth's avatar
KarlOnEarth
Frequent Visitor
5 years ago

Images stored on SharePoint broken image icon

So, I have created a report pulling images from attachments to List items. I get the fully formed URLs which, when I categorise them as Web URL and click on them they open an image. I then change the...
Need Help
KarlOnEarth's avatar
KarlOnEarth
Frequent Visitor
5 years ago

lbendlin, thanks for your response. No I hadn't considered that and I don't know how to do it. Are you able to point me to a resource to start me off? 

Finding it pretty frustrating that a M$ product cannot display resources stored on M$ infrastructure.

Maprock's avatar
Maprock
New Member
5 years ago

Hi KarlOnEarth did you get a solution to your problem.

I have the same problem.

 

- I can successfuly view an external image from a public URL in a powerbi visual where the URL is of type "Image URL".  Works fine.

- I copied this exact same image onto my sharepoint 365 portal and placed in a normal folder with other images and non image files.

- In the power bi visual, I can click on the web URL of the image location in sharepoint and the image will appear in a browser window. 

- In the same power bi visual, I have a copy of the web URL of the image location in sharepoint configured as data category "Image URL", but only the broken image icon appears. 

- The image is a jpeg.

- The sharepoint folder is shared with anyone.

I can't figure it out.   

  • KarlOnEarth's avatar
    KarlOnEarth
    Frequent Visitor
    5 years ago

    Hi Maprock, no solution yet sorry. It appears that Microsoft don't yet have the technical expertise to make this work. All I can suggest is to pray that they might be able to find and employ someone who can make it work for them. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi KarlOnEarth 

      I have a test to get image from sharepoint in Power BI.

      Firstly get data by Sharepoint Folder connector in Power BI Desktop.

      Here we need Sharepoint site url.

       

      https://****.sharepoint.com/sites/***/

       

      Then transform the Table in Power Query Editor, we need to add a custom column as below. This column is image url we need.

      Click apply and change column categroy to image url in column tool.

      Result is as below.

      Power BI Desktop will show broken.

      Power BI Service will work well.

      Video: https://www.youtube.com/watch?v=tsQM8MKxxcc

      Please check whether your Power BI account have access to your sharepoint. Here I use same account in sharepoint and in Power BI.

       

      Best Regards,
      Rico Zhou

       

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

      • KarlOnEarth's avatar
        KarlOnEarth
        Frequent Visitor
        5 years ago

        Anonymous thank you for your detailed repsonse. I did exactly as you suggested. But when I check in the service, after I have published the model, the images are still broken:

        If I copy one of the URLs out of the desktop model and paste it into my web browser, I'm logged in to sharepoint with the same user as my Power BI user, I see the image in my browser which seems to indicate that the user has access to the images.

        Do you have any other suggestions as to what I can check?