📊Power BI: SharePoint List - Image Columns

In this video we will learn how to show SharePoint List Image Columns in a Power BI Report. Since the actual image is not saved in the image column, just using that column will not work.
The column is made out of a bunch of key:value pairs that provide the necessary information of where the actual image is stored. With a little bit of data transformation in Power Query, we can put together a dynamic Image URL that Power BI can use to go and fetch our image for each row.
0:00 Introduction
0:30 The data source and the image column
0:58 Power BI - Connecting to SharePoint
1:50 Removing unnecessary columns
2:30 Transforming the Image column
8:25 Visualizing the data
9:37 Explaining the problem in Power BI Desktop
10:28 Publishing to Power BI Service
10:57 Solution, Conclusion, Closing
If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:
• Power Automate & Share...
Feel Free to follow me on other social media platforms as well:
linktr.ee/EneaLicaj
Buy me a pizza 🍕- bmc.link/enealicaj

[@gabrielsarzaud3497]

Well explained, step by step approach ! Thanks

[@Flyhigh099]

Thank you for the info

[@elymeireles2417]

Que top, resolvido meu problema, obrigado

[@mohamedamine7839]

Too useful ! Thanks

[@renatobazan7328]

Muy bueno, saludos desde Peru

[@digomattos93]

Great video, thanks. I found out a built-in power bi function that automatically transforms JSON into columns: "parse JSON" in 'add column' section of Power Query. I think it can be easier than manually split the columns.

[@kamilskwarski5057]

tried that, yet correct url is often not gathered from the SharePoint - apart the few correct links I'm getting nulls in most of the cases any idea why?

[@Enea]

Never had that issue to be honest, how does the "incorrect url" look like?

[@kamilskwarski5057]

@@Enea it's just blank... It's getting the first one, others are missing

[@vinaykumar-sl3qr]

Can the End users in the organization see the images, if i publish the report into Organisation Power BI Service? Please confirm. Thanks in Advance!

[@Enea]

If they have access to the SP List where the images come from, they should. Why don’t just try it out?

[@alfonsolans]

Great Job Buddy thanks for sharing appreciate your awesome input, quick question if I want to leave as a Regular process into my BI Data, every time that I will add a picture it will do the same or not, also what about when you have multiple picture columns in sharepoint list

[@alfonsolans]

Not to worry Buddy Thanks for your help, I already figured out, it works, Great Job and Again Thanks for sharing this great tip appreciate it and Keep Rocking

[@Enea]

Thanks mate :)

[@rovanmohamed9280]

You are Genuious

[@erikanaya9502]

I have then problem using OneDrive, Any Suggest ?

[@Enea]

What excactly is the problem then?

[@user-xs2mt9gg7d]

Hi Enea, that's great and functional, but i have one question, if i want to publish my report (website public) i can´t see the picture, and i don´t know why? can you help me with that, please :(

[@Enea]

The answer is in your question, website public. The images are saved in SharePoint and that storage is not public. The users need to have credentials and access. That will not work my friend, your storage needs to change

[@user-xs2mt9gg7d]

but, what if i change the sharepoint configuration? for everybody can see it, no just the users who credential?@@Enea

[@Enea]

I don’t think that is even possible. Then everyone in the world would be able to access that SharePoint site. Just googled a bit and did not find anything helpful

[@Hashemcom007]

Hi many thanks for your help it help me get setup a few months back. Unfortunately there appears to be a new update that means images in secure sites like sharepoint and onedrive will no longer display in power bi visuals. It was working fine for months until this update occurred. Please let me know if you work out a work around for this as have already setup a system depending on images in sharepoint Quote from ms article: ‘The URL must be anonymously accessible, not on a site that requires a sign-in, such as SharePoint or OneDrive for work or school.’

[@Enea]

Hi, is the message visible in Power BI Service? So it happenes after publishing right, not in PBI Desktop?

[@Hashemcom007]

Just managed to sort it. Looks like was a permissions issue. I seitched from cloud connection to gateway connection and started showing the images again

[@aarounge]

we can hardly read the text of the screen ur sharing , plz zoom into the screen when recording.

[@Enea]

Thanks for the feedback, sorry about that

[@DontTrip41]

Can’t see the content clearly.

[@Enea]

Sorry about that, I will be more careful in future videos, for now try to zoom in