📊Power BI: SharePoint List - Image Columns
Вставка
- Опубліковано 21 лип 2024
- 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 - Наука та технологія
Que top, resolvido meu problema, obrigado
Well explained, step by step approach ! Thanks
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.
Muy bueno, saludos desde Peru
Thank you for the info
Too useful !
Thanks
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?
Never had that issue to be honest, how does the "incorrect url" look like?
@@Enea it's just blank... It's getting the first one, others are missing
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
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
Thanks mate :)
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!
If they have access to the SP List where the images come from, they should. Why don’t just try it out?
I have then problem using OneDrive, Any Suggest ?
What excactly is the problem then?
You are Genuious
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.’
Hi, is the message visible in Power BI Service? So it happenes after publishing right, not in PBI Desktop?
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
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 :(
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
but, what if i change the sharepoint configuration? for everybody can see it, no just the users who credential?@@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
we can hardly read the text of the screen ur sharing , plz zoom into the screen when recording.
Thanks for the feedback, sorry about that
Can’t see the content clearly.
Sorry about that, I will be more careful in future videos, for now try to zoom in