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 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?
Sharepoint does not have limitation of 32k characters, not sure if this is an issue for you too or just for initiator of the thread (base64 there was on Sharepoint). PowerApp also does not have this limitation. I have a table in PBI which maps SP list ID to the document, and this is what I pass to from PBI to PowerApp. Gallery in PowerApp has SP list as a source, and ThisItem is constructed using input from PBI to get path to the item you want to see.
You build PowerApp launching it from PBI (i.e you add visual, drag fields you need, and this will start the process, and you add SP as a source to PA). Both PBI and PApp need access to SP.
