Power query a *.PDF file from google drive

[debun]

I have a .pdf file in my google drive that i would like to use power query to bring into my an excel sheet. I found a youtube that describes how to connect google sheets

but renameing the extension to pdf does not work. Does anyone know of a good solution?

 

[AlanSidman]

Her file is already an xls type file. You have indicated that you are looking to import a PDF. In PQ, you just need the path to extract the PDF from Google. If this is not what you want to do, then you need to re-explain in more detail.

 

[debun]

Her file is already an xls type file. You have indicated that you are looking to import a PDF. In PQ, you just need the path to extract the PDF from Google. If this is not what you want to do, then you need to re-explain in more detail.

The default direct link from google does not work in PQ. She is showing the fix for xls. I need one for a pdf.

 

[AlanSidman]

Maybe this will help

https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

 

[debun]

Maybe this will help

https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

Unfortunately no, google docs are not a folder

 

[AlanSidman]

The few google docs I have are all located in a "folder" called Google Drive. Good Luck as I am bowing out as I only use Google Docs under duress.