Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Community,
I am trying to use the PDF Viewer visual from the AppSource. It mentions that the PDF must be converted to Base64. I am trying to execute this in PowerQuery as a custom column using the below code.
Binary.ToText([Content],BinaryEncoding.Base64)
Hi,
I found a good article:
https://customertell.com/displaying-pdf-files-stored-in-sql-server-in-power-bi/
@Anonymous so you were able to get that Power Query function to convert on the fly to base64?
I want to find a way to do this where it doesn't require manual work each time new PDFs are added to folder.
We have went with a different strategy that offered a bit more flexibility to searching the PDF pages. We created a .jpg image for each page and used that in our BI with the "Image" app from the AppSource.
@Anonymous I tried this visual and it worked as expected when I used python outside of Power BI to get the encoded string. Please check their documentation and examples.
I'd assume something breaking when the binary import is being done, can you please describe your process?
Thanks for the response!
I have a pdf file on my desktop, I am point to that in power query, then creating a custom column where I use the code mentioned in the original post to create the Base64 string.
The string looks that same as when using other tools to create, but I can't get the visual to work. How would I integrate your Python method into what I'm doing?
I have very limited Python experience.
@Anonymous Ok, your approach worked for me, so I suspect it may be due to limitation of the 30,000 characters. So, please follow their example and split up the text field further into multiple fields and see if it works.