Upload module in Power Query Online

The Upload module brings a file from your computer into Power Query Online. Use it when you have a local file to work with rather than an existing online file URL or database connection.

Screenshot of the Upload module.

Upload and connect to a file

  1. In Get data, select Upload.
  2. Drag a supported file into the upload area, or select Browse and choose the file on your computer.
  3. Complete the connector-specific settings that follow. Wait for the upload to finish, and sign in with an organizational account when required.
  4. Continue through the file's connection and preview experience, and review the resulting query.

The upload feature supports Excel, JSON, PDF, Text/CSV, and XML files through their corresponding connectors. For the supported filename extensions, authentication steps, and upload status messages, go to Upload a file.

Where the file is stored

Uploaded files are stored in your OneDrive for work or school account. The result is a query that reads the uploaded file, not a connection to the original path on your computer. Don't assume that editing the original local file updates the uploaded file.

If your file already resides in SharePoint or OneDrive for work or school, consider connecting to the existing online file rather than uploading another copy.

You can also start an upload by dropping a file onto the editor's diagram view or queries pane. For that separate entry point, go to Drag and drop experience in the query editor.