cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lukas1
Advocate III
Advocate III

Reduce file size of camera images

Hi,

in my application the user can take pictures with the embedded camera-feature. These images are stored as base64 in a sharepoint list.

 

In a Power BI dashboard I want to show the images taken with the app. But unfortunately Power BI has a size limit for base64 images which results in broken images.

 

The feature to use optimized image quality is already enabled. I also don't find any Power Automate action to re-size or compress images.

 

I am looking for a solution that works without paid third party solutions.

 

Any ideas?

Thanks,

Lukas

4 REPLIES 4
v-jefferni
Community Support
Community Support

Hi @Lukas1 ,

 

Could you please share more details about your scenario? Do you mean that Base64 string is too long for Power BI or the image size is too big?

 

I have no idea that Power BI would restrict image size, if it is the image size issue, you could use the substitute function to replace "png" with "jpeg" to make the image smaller.

 

If you do mean that Base64 string is too long, I'm afraid there is no way to reduce the string length directly in PowerApps. As a workaround, you could use Flow to update the image to SharePoint library or OneDrive and other cloud services then retrieve the URL to SharePoint list and apply it in Power BI.

 

You could know how to upload images to SharePoint library:

https://www.youtube.com/watch?v=3QaiM8SeWfM

 

The Flow would be very simple with 3 steps since you know how to get Base64 string of the image. Basically like below:

11.png

 

Hope this helps.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

 

@v-jefferni, thanks for your reply.

 

When I capture an image with the ipad camera the image resolution results in a base64-string that is too long for PowerBI.

 

I tried the workaround suggested by you and saved the image in a sharepoint library. That solves the problem with the image/base64 size but I am running into the next problem: Apparently PowerBI does not allow to show an image based on a sharepoint-URL if the link is not open for everyone (even outside the organisation which is no option for my use case). On the PowerBI side there doesn't seem to be a solution for this.

v-jefferni
Community Support
Community Support

Hi @Lukas1 ,

 

As per you mentioned, you could create the image in OneDrive or Google Drive or other cloud storage services and set up the permission to everyone could see the file with a link, then apply this link (responded from the Flow) in Power BI dashboard.

 

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

v-jefferni
Community Support
Community Support

Hi @Lukas1 ,

 

Have the issue been resolved? If you have any further questions, please feel free to let us know.

 

Best regards,

Community Support Team _ Jeffer Ni

If this post helps, then please consider Accept it as the solution to help the other members find it.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,570)