Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Connecting photographs

Newbie here and due to go on my first Power BI training course in May - super excited as Power BI looks like it has SO much potential.  We have a bunch of reports built for us and the advantages are mind blowing already!

One thing I have tried is creating a MS form in teams for my team to submit a monthly project update.  As part of this they upload a photograph each month.

When I get the excel download with the hyperlinks to the photographs, Power BI will not pick up the links to the photos.

After some intense googling (that is a real thing lol) I realised that Power BI will only pick up an image URL if the image is on the world wide web and open to anyone.

I tested this with some random images and it worked. (using the visual Image Pro by Cloud Scope)

So my question - is there any way to get Power BI to pick up photographs with the URL in a secure area?  We cannot have our photographs out there on the web so am looking to find an alternative and having no luck.

Any ideas or is this just a no-no?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

The answer to this is you cannot connect photographs to Power BI unless they are in an open access area.  For our business this is not possible as we cannot hold any business content in the open web.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

The answer to this is you cannot connect photographs to Power BI unless they are in an open access area.  For our business this is not possible as we cannot hold any business content in the open web.

Anonymous
Not applicable

Hi Gao - thank you for your reply.  I scanned the blog you mentioned and it is beyond my level for now.  It also looks from that blog that what I am trying to do is not possible.

I wanted to have a monthly report updated through Teams Forms and then connect to Power BI but from reading the blog it looks like I would need to manipulate every single URL and compress every single file every month.  As there will be about a number of photo updates every month this will take up too much time.

Shame as I think it would be really cool.

Maybe down the line once I am more experienced I will have another go 🙂

Have a great weekend.

Warm Rgds

Yvonne

v-cgao-msft
Community Support
Community Support

Hi @Anonymous ,

 

You can convert images to Base64 for storage in tables in PowerBI. Please refer to blogs in this link.

Chris Webb's BI Blog: Storing Large Images In Power BI Datasets

 

Best Regards,
Gao

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.