cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MikeHawryluk Regular Visitor
Regular Visitor

Displaying images from sharepoint online list or folder

Hi all...

 

I have images loaded in a SharePoint list that I want to display in a Power BI report. Hoping someone has seen this scenario:

 

Desktop: No issue to connect to the list and display data. Images show broken links which I expected. I'm not worried about this as there is no expectation to consume in the desktop.

 

Service: I upload the pbix file, connect SharePoint for refresh and can view the images in the report with no issue. Everything works perfectly.

 

IOS or Android App: Images will not load.  

 

If the user switches to the mobile browser on iOS or Android there is no issue but I would really like this to work across all platforms.

 

Suggestions?

12 REPLIES 12
Moderator v-qiuyu-msft
Moderator

Re: Displaying images from sharepoint online list or folder

Hi @MikeHawryluk,

 

Based on my test in Power BI app version 111655 on andriod and Power BI app version 13.8 in iphone, the image URL from SharePoint list can display fine. In your scenario, please run the same mobile version as ours.

 

1975408326.jpgandroid1.pngiphone

 

By the way, the Power BI desktop used to create pbix file is also the latest version 2.49.4831.521 64-bit (August 2017).

 

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MikeHawryluk Regular Visitor
Regular Visitor

Re: Displaying images from sharepoint online list or folder

Hi @v-qiuyu-msft

 

Thank you very much for your response.  One question:  Are the images you are using public or are they restricted to the organization in SharePoint.  In my case, the images are restricted to members of the SharePoint site.  Will this affect the result?

 

My images are displaying fine via the browser on all devices.

 

The app versions are: Android 111680, IPAD 13.9 and Desktop 2.49.4831.521 64-bit (August 2017).

 

 

 

Moderator v-qiuyu-msft
Moderator

Re: Displaying images from sharepoint online list or folder

Hi @MikeHawryluk,

 

The image test in my environment come from Internet:

 

https://upload.wikimedia.org/wikipedia/commons/thumb/0/0f/Grosser_Panda.JPG/1200px-Grosser_Panda.JPG

https://i.pinimg.com/736x/5d/08/a4/5d08a4106d10d9960319514f8b9c85da--pandas-cute-cute-bear.jpg

 

You can try the same images in your scenario to see if the issue happens.

 

I don't think the issue related to the permission to view image in SharePoint, as dataset owner already enter credential for the SharePoint list data source in Power BI service, any one view the report use the same credential to access the SharePoint list.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MikeHawryluk Regular Visitor
Regular Visitor

Re: Displaying images from sharepoint online list or folder

Hi @v-qiuyu-msft 

 

There is no issue displaying images from public sources such as the web.  I am able to display the images you used on both apps with no issue.   

 

The issue is displaying images that are stored on SharePoint online and the issue only occurs in the apps.  The PowerBI users have access to both the PowerBI workspace and the SharePoint site we are using.  

 

 

 

Mike  

Moderator v-qiuyu-msft
Moderator

Re: Displaying images from sharepoint online list or folder

Hi @MikeHawryluk,

 

I can reproduce this issue on my side. I have reported it internally, will let you know if get any information.

 

Best Regards,
QiuyunYu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MikeHawryluk Regular Visitor
Regular Visitor

Re: Displaying images from sharepoint online list or folder

Thanks very much for your help @v-qiuyu-msft

Moderator v-qiuyu-msft
Moderator

Re: Displaying images from sharepoint online list or folder

Hi @MikeHawryluk,

 

Please see below response from PG team:

 

The mobile apps do not work like the web application which uses cookies for authentication and that’s the main reason.

 

Possible workarounds:

 

  1. Transform the images to base64 string and place it in the model - see attached, you can share with customer, there are instructions in it.
  2. Use PowerBI DAX UNICHAR function – there is an external blog post with nice explanation here: https://blog.crossjoin.co.uk/2017/04/11/the-dax-unichar-function-and-how-to-use-it-in-measures-for-d...
  3. It depends on clients’ need but PowerBI Conditional formatting - https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-conditional-table-formatting/ might solve requirements
  4. Place images in a public resource that doesn’t require authentication

 

Best Regards,
QiuyunYu

 

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Benjamin_C Regular Visitor
Regular Visitor

Re: Displaying images from sharepoint online list or folder

Hi all, this seems a bit surprising (not to say shocking) to see it's almost impossible to show pictures from from url linked SPO to or OneDrive knowing that 1- Power BI is designed to be visual (and what's more visual than a picture?), 2- SPO or OneDrive are Microsoft tools commonly used in business environement... Are developpers working at solving this issue or is it here to stay? Thx a lot from your feedback!

bhavikv9488 Occasional Visitor
Occasional Visitor

Re: Displaying images from sharepoint online list or folder

Hello Mike,

 

I do not intend to jump on to your conversation. But I am facing an issue while displaying the images from the Resctricted/Internal  Sharepoint location. I have 4 images to be displayed based on the conditions based on the data in the table visual. My URL shows broken icon and doesnt display the images. Is there any options I need to check. I have been trying to find the solution for a while but cant find anything.

 

Thanks in Advance !

 

Bhavik