Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PDF Viewer Help - PDF to Base64

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...
Need Help
sanimesa's avatar
sanimesa
Post Prodigy
6 years ago

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?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

sanimesa 

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.

 
 
 
  • sanimesa's avatar
    sanimesa
    Post Prodigy
    6 years ago

    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.