Easy Tech TutsHow to Connect Google Drive Folder to Power BI (Cloud File Setup) Easily 2026
By Impran M NLast checked against official docs
Power BI has no connector that browses a Google Drive folder the way it browses OneDrive or SharePoint. What it does have is a Google Sheets connector, generally available in Power BI Desktop, semantic models and dataflows.
You give it one sheet's URL, sign in with a Google account that can open that sheet, and Power BI reads the data from Google's cloud directly. So "connecting a Drive folder" in practice means connecting each sheet in that folder, one URL at a time. This guide walks through the connection, then the scheduled refresh that keeps the report current.
Before you start
- A Google account with access to the sheet. It doesn't need to be the owner, and the sheet doesn't need to be public.
- Power BI Desktop, plus a Power BI service account if you want to publish and schedule refresh
01Copy the sheet's URL
Open the sheet in your browser and copy the address from the address bar. The connector checks that the URL starts with https://docs.google.com/spreadsheets/d/, pulls the spreadsheet ID out of it and ignores the rest.
A drive.google.com folder link won't work. You don't need to change sharing to "Anyone with the link".
Power BI signs in to Google as you in the next steps, so the sheet only has to be visible to your account. Sheets on shared drives are supported.
02Choose Google Sheets in Get Data and paste the URL
In Power BI Desktop, open Get Data and search for Google Sheets. It isn't filed under a Drive or folder category.
The dialog that opens has one field, the Google Sheets URL. Paste the address and confirm.
03Sign in with Google and click Connect
Select Sign In. A Sign in with Google window opens in your external browser.
If you're already signed in there, it shows your account with a "You are currently signed in" message and an option to sign in as a different user. Pick the account that can open the sheet, which matters when you keep work and personal Google accounts side by side, and approve the connection to Power BI Desktop.
Back in Power BI, select Connect. Every new sheet URL counts as a separate data source, so you'll authenticate again for each sheet you add, although an active Google session often saves you retyping the password.
04Pick the tabs in the Navigator and load
The Navigator lists the sheet's tabs. Tick the ones you want, then choose Transform Data to clean them in Power Query or Load to bring them straight in.
Transform Data is usually the better first choice. Dates and numbers from Google Sheets often arrive typed as text, and fixing that in Power Query is far easier before you've built visuals on top.
05Publish and schedule the refresh
Publish the report to the Power BI service. Open the workspace, select the semantic model and choose Refresh > Schedule refresh.
Under Data source credentials, sign in to Google again so the service can reach the sheet, then switch Configure a refresh schedule to On and set your times. Two rules from Microsoft catch people out later.
The schedule is switched off after four consecutive failures, and it's paused after two months in which nobody opens a report built on the model. Refresh > Refresh history shows why a run failed.
When it doesn't work
Power BI rejects the URL you pasted
Why: It isn't a sheet address. The connector only accepts URLs beginning with https://docs.google.com/spreadsheets/d/, so Drive folder links and drive.google.com file links fail.
Fix: Open the sheet itself in Google Sheets and copy the address bar from there.
An Excel file stored in Drive won't load
Why: The connector reads data through the Google Sheets API using the spreadsheet ID. An uploaded .xlsx that hasn't been converted isn't a native Google Sheet.
Fix: Open it in Google Sheets and use File > Save as Google Sheets, then connect to the new sheet's URL.
Scheduled refresh shows as Disabled
Why: Either four refreshes failed in a row (often expired Google credentials), or nobody viewed a report on the model for two months.
Fix: Check Refresh history, re-enter the Google sign-in under Data source credentials if needed, then turn Configure a refresh schedule back on and select Apply. For an inactivity pause, opening any report on the model is enough before re-enabling.
Frequently asked questions
Does Power BI have a Google Drive folder connector?
No. Its native Google options are the Google Sheets connector and Google BigQuery. You connect each sheet in a Drive folder individually by URL.
Does the Google Sheet need to be shared publicly?
No. The connector signs in with your Google account, so the sheet only has to be accessible to that account.
Will moving or renaming the sheet break the connection?
Not by itself. Power BI keys the connection to the spreadsheet ID inside the URL, and moving or renaming a sheet in Drive keeps that ID. Making a copy creates a new ID, so a copied sheet needs a new connection.
How often can Power BI refresh Google Sheets data?
Up to 8 scheduled refreshes a day on Power BI Pro, and up to 48 on Premium Per User or Premium/Fabric capacity.
Sources and last check
Connector and sign-in screens come from a recorded walkthrough in Power BI Desktop. The connection steps, URL rules, shared drive support and refresh limits were re-checked against Microsoft Learn documentation in September 2026. That check corrected two earlier claims in this guide: the sheet does not need an "Anyone with the link" share, and moving the file within Drive does not break the connection.
About the author
Impran M N
I've been hooked on technology for as long as I can remember — especially the new tools and AI apps that seem to land every other week. Easy Tech Tuts is where I write up whatever I've just worked out: I do the task in the real product, record the screen, and turn it into the guide I wish I'd found first.
