SharePoint Image to Paginated Report Display Issue

[The8]

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 

[d_gosbell]

Your problem is the second bullet point from this link https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/images-report-builder-ser... External images cannot require authentication and everything in Sharepoint is authenticated. You either need to store the images somewhere else or look to embed them within a database so that the paginated report can pull them down with the query.

[The8]

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]

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]

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!!