Upload a file (Preview)
You can upload files to your Power Query project when using Power Query Online.
The following connectors currently support the upload a file feature.
Note
Only files with the following extensions are supported for upload: .csv, .json, .pdf, .prn, .tsv, .txt, .xl, .xls, .xlsb, .xlsm, .xlsw, .xlsx, .xml.
When you select a connector that offers the Upload file experience, you will notice a radio button on the top that enables this feature.
When you select Upload file, the option underneath opens a simple dialog to let you either drag a file or browse in your local file system to upload a file.
After you've selected your file, a progress bar shows you how the upload process is going. Once the upload process is finished, you'll be able to see a green check mark underneath your file name, with the message Upload successful and the file size right next to it.
Note
The files that are uploaded through this feature are stored in your personal Microsoft OneDrive for Business account.
Before you select the next button, you need to change the authentication kind from Anonymous to Organizational account and go through the authentication process. Start this process by selecting Sign in.
After going through the authentication process, a You are currently signed in message underneath the Authentication Kind selection let's you know that you've successfully signed in. After you've signed in, select Next. The file is then stored in your personal Microsoft OneDrive for Business account, and a new query is created from the file that you've uploaded.
When using the Power Query editor, you can drop a file on either the diagram view or the queries pane to upload a file.
When dropping the file on either of the previously mentioned sections, a dialog with the appropriate connector settings page will be shown, based on the file extension of the file that's being uploaded.