Displaying Photos of students that are stored locally on a PBi Workspace in the cloud

[BrianHarry]

I have a reported that I have migrated from SSRS to PBI Premium Workspace. The old RDL file references photos that are stored locally on an internal server. Does anyone know the best way to store these in the cloud and also display them within the PBI Report, each photo is linked by Student ID within the report?

Shall I move these to Onedrive or a SharePoint Library and then try and reference these in the report, not sure what to do.

Kind regards

Brian

[Greg_Deckler · Accepted solution]

@BrianHarry You just need to store the URL to the image in a column in a table. You then choose that column and under Column Tools you set the Data category to Image URL. Then, if you use that column in a table visual, you will get the image displayed. For example, here is an article I wrote a long time ago that goes through it: Dates Prior to 1900 in DAX - Microsoft Power BI Community

[Greg_Deckler · Accepted solution]

@BrianHarry You just need to store the URL to the image in a column in a table. You then choose that column and under Column Tools you set the Data category to Image URL. Then, if you use that column in a table visual, you will get the image displayed. For example, here is an article I wrote a long time ago that goes through it: Dates Prior to 1900 in DAX - Microsoft Power BI Community

[Greg_Deckler]

@BrianHarry You just need to store them anywhere that allows you to have anonymous access via a URL so OneDrive or SharePoint library would work depending on permissions. Azure blob storage might be an inexpensive way to do it.

[BrianHarry]

Woudl you have any examples of this to share and the commands to use if possible, as i am new to Pbi

[Greg_Deckler · Accepted solution]

@BrianHarry I found the file I used in that article and attached it below signature.