You can use the following strategies to improve performance and reduce timeouts when you access large PDF files. Limitations and considerations Accessing large PDF files In Navigator, select the file information you want, and then select Transform Data to continue transforming the data in Power Query Editor. If this is the first time you've accessed this PDF file, select the authentication kind and sign in to your account (if needed). If necessary, select an on-premises data gateway to access the PDF file. If you're loading a local file, you can also select Upload file (Preview) to browse to the local file or drag and drop the file. In the PDF dialog box that appears, either provide the file path or the URL to the location of the PDF file. To make the connection from Power Query Online: In Navigator, select the file information you want, then either select Load to load the data or Transform Data to continue transforming the data in Power Query Editor.Ĭonnect to a PDF file from Power Query Online If the PDF file is online, use the Web connector to connect to the file.

Select the PDF option in the connector selection.īrowse for and select the PDF file you want to load. To make the connection from Power Query Desktop: PrerequisitesĬonnect to a PDF file from Power Query Desktop PDF is not supported in Power BI Premium.

Office 2016 power query