Importing PDF data into Excel - With No Link back to the Data

Copper Contributor

Hi Everyone

 

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.

 

Many thanks

 

Keith

1 Reply

@Keith Farmery Towards the end ("Advance refresh options") of the attached article , you can read how to set individual queries' behaviour regarding regarding Refresh.

https://exceloffthegrid.com/power-query-data-refresh/