Forum Discussion
Base64 Images
Hi mmattar ,
Actually, PowerBI has a limitation in the size of Base64 column, but I haven't found a document describing this. Besides, we can't find a method to reduce the size of Base64, you can consider reduce the quality of image and convert it to Base64 again.
As a workaround, we can upload the image to server, then use the image url to display it.
Best Regards,
Teige
Hi mmattar ,
Some Online storage provider like Azure or Onedrive can provide the web url for a picture, https://www.fourmoo.com/2017/09/26/power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/
Best Regards,
Teige
Hi TeigeGao , can you elborate a bit more on "we can upload the image to server, then use the image url to display it"
Thanks
Hi mmattar ,
Some Online storage provider like Azure or Onedrive can provide the web url for a picture, https://www.fourmoo.com/2017/09/26/power-bi-using-onedrive-to-embed-and-host-images-for-power-bi/
Best Regards,
Teige
How would I do something like this programmatically through Power BI's power query editor for a OneDrive Folder?
Currently, I created a custom column to convert the image to Base64, and ran into the clipping issue mentioned above, and I created a custom column that concatinated the file name and folder path and applied the picutre url category to it, but to no avail. So short of going into the image folder and manually resizing each image one by one, and testing until unclipped, I'm not sure if there's a way to auto generate the embedded url for each image. I'm all about saving time haha.
I am using simple PowerApp (really, document library and specifically pdf viewer) as a visual in PowerBI to display base64 stored on Sharepoint. I am passing document ID from PowerBI to PowerApp visual, and document is displayed in PBI
I used this video:
https://www.youtube.com/watch?v=GFfAkk3g1y8I just viewed that video, it looks promising but its connecting to Power App, so to make sure I got the concept generally correct, the unlimited character base64 would fully populate in Power BI without needing to break up the base64 images into chunks, and without having to do resizing tomfoolery with the images before converting to base64 and storing as a link in PBI?
Also, how did you get the connection to PBI? Was it from the Power App or directly from sharepoint?
