Forum Discussion
PDF Viewer
Hi
I am struggling with the PDF Viewer visual. I am testing 3 PDFs saved in my onedrive account.
I have connect to the folder where these are located and added a custom column to change the format to Base64
=Binary.ToText([Content],BinaryEncoding.Base64)
However when I use the visual the only PDF that is visible is the 'Test PDF Web' PDF which is 4KB in size. The other PDFs are not showing in the visual.
Can you please advise what steps I need to take in order to resolve this issue.
Richard
3 Replies
This blog may help you.
It demonstrates how you can use an M query that reads all the data from all of the files in the folder and converts them using"Binary.ToText(BinaryIn, BinaryEncoding.Base64)" to store them as text in a table.
https://blog.crossjoin.co.uk/2019/05/19/storing-large-images-in-power-bi-datasets/
- PREVIEWJust to let you know I read the Chriss Webb blob in the hope it would resolve my issue. Although the M-Code provided produced no errors the outputs were blank. I have therefore contacted Chris Webb directly via his blog in a hope for an answer.Because of this I will not accept as a solution yet until I have received a response from Chris and hopefully a reason why my outputs are blank . Thank you again.RIchard
Thank you V-lianl-msft I will take a look at Chris Webbs blog post later today to see if this resolves my issue
