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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
YvonneG
Advocate I
Advocate I

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
YvonneG
Advocate I
Advocate I

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
YvonneG
Advocate I
Advocate I

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.

YvonneG
Advocate I
Advocate I

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 @YvonneG ,

 

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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