Forum Discussion
Import PDF images
Hi there,
I am currently trying to create a Power BI report based on our RAG data. The initial data is only available as a PDF (not an issue) with the text aspects, however the actual R A G symbols come through as '[image]' when I import the PDF tables.
Does anyone have a solution for this e.g. for it to read these images as text R, A, G or " "
Many thanks
RAG images look like this:
3 Replies
v-lili6-msftCommunity Support
hi, Anonymous
I think the simple way is that you may use Replace values in edit queries to replace these images with text R, A, G or " ".
https://realizeddesign.blogspot.com/2016/06/power-bi-replacing-values-using-query-editor.html
Best Regards,
Lin
Hi v-lili6-msft,
Not sure I explained myself clearly enough in the initial post. When I import the PDF, every instance where you see the image of e.g. red circle with the 'R' in etc., that is being imported in text format as "[image]".
Therefore not possible to replace values as all RAG statuses are shown as the text "[image]".
Any thoughts?
- v-lili6-msft
hi, Anonymous
Could you share a simple sample pdf file for us have a test?
Best Regards,
Lin