How to Connect Google Drive Folder to Power BI (Cloud File Setup) Easily 2026

Open the Google Sheet you want to report on and use Share to generate a link, making sure sharing is set to at least "Anyone with the link can view" — Power BI needs to reach the file over the web, and a link restricted to specific people it can't authenticate as will fail silently. Copy the full URL from the address bar or the share dialog; you'll paste this directly into Power BI in the next step, so keep it on your clipboard or in a notes file rather than retyping it.

In Power BI Desktop, choose Get Data and search for Google Sheets rather than looking under a Google or Drive category, since that's the specific connector Microsoft ships for this. Selecting it opens a small dialog with a single field for the Google Sheet URL. This is the actual mechanism behind "connecting a Drive folder" in practice — you're not browsing a folder tree the way you would with OneDrive, you're pointing Power BI at one file's address directly.

After pasting the URL and confirming, Power BI opens a Google authentication window. If you're already signed in on that machine, it shows your current account with a "You are currently signed in" message and a Sign in as different user option — useful if the sheet lives under a work account separate from your personal Google login. Pick the account that actually has view access to the file; signing in with the wrong Google identity is the most common reason this step silently fails to connect.

Once authenticated, Power BI reads the sheet's tabs and presents them in the Navigator, where you select which ones to load, similar to how it handles a multi-tab Excel workbook. Review the column headers and data types before clicking Load, since Google Sheets doesn't always type columns as cleanly as Excel does — dates and numbers imported as text are a common cleanup step you'll want to catch in Power Query before building visuals on top of them.

This setup is only as reliable as the URL you connected to, so avoid moving the Google Sheet to a different folder or changing its sharing permissions after the fact — either can break the refresh without any obvious error message pointing to the cause. If your team reorganizes Drive folders often, it's worth keeping a single "reporting source" folder that stays put, with the actual sheets living inside it, so the links Power BI depends on never have to change.

Publish the report to the Power BI service and set a scheduled refresh from the dataset settings, the same as you would for any cloud-based source. Because the underlying connector authenticates against Google rather than Microsoft's own cloud, double-check that the scheduled refresh completes successfully after publishing — mismatched account permissions between your desktop session and the service account are a common first-run snag worth catching early rather than discovering during a live report.