On a regular basis, I import data from PDF documents using PowerQuery.
The PDF data is not dynamic, it will not change, so I do not need the link back to the data in order for it to refresh.
Is there any way I can import the data from my PDF file and not end up with a redundant link back to the data? I am aware that I am able to delete the link manually, I would just like it if I could import the data into the spreadsheet.
Any help or suggestions would be gratefully received.