The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I would like some advice on how to proceed with adding images to my Power BI report. I have a table that has building information, such as name, address, square footage, year built. This information is extracted from an Access database to Excel and transformed using Power Query for Power BI. I would like to include an image of the building on the report page with all the building's attributes.
Is there a preferred method for doing this? I would want to be able to replace the photo and refresh the data and have the new photo displayed. For example, if the image is hosted on our file server and I name it a standard naming convention such as, <Building#>.jpg. When I get a new picture, I write over <Building#>.jpg with the new image, refresh and the new image is displayed.
Or if it is better to host the images online, just looking for some direction.
Thank you,
Carol
Solved! Go to Solution.
@samye228 yes it is better to host images online with some naming convention and then create that URL in PQ and set the category type of that column to the image URL and it will show the picture. As the picture gets updated, it will use the new image using the URL. The Main components are to create a standard naming convention and add the image URL column in PQ.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi, @samye228
Thanks for parry2k's reply. This Youtuber out gives a useful method to display the image properly when you have done everything to prepare it and publish it to the Service.
After modifying the image in Salapon, you need to clear your browser cache so that the image in Servis will display properly
Best Regards,
Yang
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
@samye228 check out this video A little trick for SharePoint Online Images in Power BI - YouTube
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@samye228 yes it is better to host images online with some naming convention and then create that URL in PQ and set the category type of that column to the image URL and it will show the picture. As the picture gets updated, it will use the new image using the URL. The Main components are to create a standard naming convention and add the image URL column in PQ.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
would SharePoint work as a file server?