Getting data from google drive folder

[ahmedshalabyy12]

Hello,

I want to get data from a google drive folder but I cannot do that with Power BI , I have googled this but I am stuck , therefore could someone please tell me the best practice for it .

FYI : I have sheet with different tabs so I want a particular tab from the sheet.  The format of the sheet is google sheet.

Thank you 

[v-hashadapu]

Hi @ahmedshalabyy12 , Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.

[v-hashadapu]

Hi @ahmedshalabyy12 , 

hope you are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.

[Lodha_Jaydeep]

Hi @ahmedshalabyy12,

Thank you for reaching out to the Fabric Community. I am happy to assist you in resolving this issue.

Currently, Power BI does not support a native Google Drive connector.

However, you can use the Google Sheets connector to import data from your specific sheets and tabs.

Here are the outlined steps to achieve this:

1) Open Power BI Desktop > Get Data > Google Sheets.

2) Select the Google Sheets option; you will be prompted to enter the URL of the spreadsheet you wish to connect.

Note: Upon clicking "Connect," a prompt will appear. Please click Continue to proceed.

3) You will be prompted to sign in with your Google account; please log in using the account associated with the spreadsheet.

4) After sucessfull signin it will ask you to pick up the tab/table from your sheet. you can then load them or transform data using the button below and start creating your dashboard/report.

If you find this response helpful, kindly consider marking it as the accepted solution and giving it a kudos. This helps others facing similar issues and is greatly appreciated.

[Lodha_Jaydeep]

Hi @ahmedshalabyy12 ,

Did you get a chance to perform the outlined steps to import the spreadsheet data into Power BI? Please let me know if it worked successfully or if you encountered any issues.

I'm happy to assist further if needed.

[v-hashadapu]

Hi @ahmedshalabyy12 , Thank you for reaching out to the Microsoft Community Forum.

Connect to the Google Sheet itself, not the Drive, using the Google Sheets connector and provide the file’s URL. Once connected, Power Query will automatically list all the tabs in that sheet and you can simply select the specific tab you need. If you’re planning to scale or automate this, I suggest you to publish the required tab as a CSV from Google Sheets and use the Web connector instead, which tends to be more stable than relying on the Sheets connector.

[Kedar_Pande]

@ahmedshalabyy12 

No native Google Drive folder connector. Power BI connects to individual Google Sheets only.

Alternative (if must stay native): Google Sheets connector → manually copy-paste each sheet ID. CSV publish cleaner long-term

[InsightsByV]

Hi,

This tutorial should help you: 

https://www.youtube.com/watch?v=crUVxlGpBmM

Please let us know if still it doesnt resolve your issue.

[danextian]

hi @ahmedshalabyy12

To my knowledge, there isn’t currently an exiting connector for Google Drive. While the Google Sheets connector can be used as a workaround, the Google API has relatively low limits and may throttle the connection periodically.

[ryan_mayu]

@ahmedshalabyy12 

maybe you can try connect to google sheet ,not google drive

https://learn.microsoft.com/en-us/power-query/connectors/google-sheets?wt.mc_id=DP-MVP-5004616