Forum Discussion

The8's avatar
The8
Helper II
2 years ago

SharePoint Image to Paginated Report Display Issue

Hi,

I have a Sharepoint List in which I have Columns with Images and I have generated a power BI report by expanding this to Image column into Image URL and published this report to PBI service.

In Power BI service I can see images from this Image column.

Now I have generated a Paginated Report using this published Dataset but I have problem displaying Images.

Problem in Power BI servie for created Paginated report looks like this below

 

I have access and authorisation to access the Sharepoint file.

The problem is similar like explaned in this video. I follwed same steps as in video below

https://screencast-o-matic.com/watch/c3heDVVYd5f.

Any suggestions. I tried to find suitable solution in MS PBI community but I couldn't able find right solution.

Thanks in advnace.

SharePoint Image to Paginated Report d_gosbell 

Need Help
Tips and Tricks

4 Replies

    • The8's avatar
      The8
      Helper II
      2 years ago

      Hi,

      As you suggested, I have changed the data source from Sharepoint to Local Computer. (Excel file as well Pictures)

      I can access and display images from Local computer in Power Bi desktop as well Power BI service but I have same issue displaying Images. ğŸ‘‡

       

      Note: I am accessing Local data to Power BI through On-Premises Gateway

      Problem is the same even when I changed the datasource from Sharepoint to local computer.

      Any alternative now?

      Thanks in advance.

      d_gosbell 
      Anonymous 


      I actually stored the images in my Local computer by name ID same as in Excel file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    HI The8,

    Have you try to use the root URL of the image files?(e.g. www.xxx.com/abc.jpg) AFAIK, the SharePoint images include additional authorization which may not be processed during report visual data load steps.

    Regards,

    Xiaoxin Sheng

    • The8's avatar
      The8
      Helper II
      2 years ago

      Hi,

      I tried Image URL from my dataset, directly in web search and this URL is working well and I can see images but I can not see the images in Paginated report.

      In paginated report also I treid both JPG as well png but I have same problem.

      URL format is as below :
      https://$company$.sharepoint.com/sites/$File Location$/$Lists$/7z65r.png

      How can I solve the Issue.

      Thanks!!