Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
smjoshi
Frequent Visitor

CSV file refresh from Google Drive

Hello

I would like to refresh CSV file kept on google drive from Power BI service. How to get data from csv kept on google drive in PBI desktop and serive refresh?

 

1. I have local csv file which I able to read in PBI desktop and desktop refresh fine

2. When loacl path csv file deployed on PBI service then refresh failed as path did not find

3. Kept the csv file onto google drive so that its accessiable to required users as well as should able to refresh from service

4. Get Data -> Test/CSV, deosn't show me google drive csv file to open in PBI desktop but it shows google sheet with "Google Sheet" connector

5. I need to use only csv file in this case so hhow to achieve 

 

Thanks

Smita

 

1 ACCEPTED SOLUTION

Hi, @smjoshi 

For now, you need to change the google share link and make the file public before using the Web connector to access it. You can also visualize Google Drive data in Power BI Desktop using ODBC drivers provided by third-party platforms.

 

Please refer to these related threads for more details.

How to Connect Google Drive to Power BI (Detail Steps) 

Google spreadsheet integration 

 

Best Regards,
Community Support Team _ Eason

View solution in original post

3 REPLIES 3
GilbertQ
Super User
Super User

Hi @smjoshi 

 

If you have the gateway installed on the same computer as the CSV file you can use this to connect to the file

 

Chris Webb's BI Blog: Configuring Power BI Gateway Data Sources For Files And Folders Chris Webb's B...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hello Gilbert

 

We don't have gateways. We connect to all cloud application thats why uploded csv to google drive thinking it will work as cloud csv copy

 

Thanks

Smita

Hi, @smjoshi 

For now, you need to change the google share link and make the file public before using the Web connector to access it. You can also visualize Google Drive data in Power BI Desktop using ODBC drivers provided by third-party platforms.

 

Please refer to these related threads for more details.

How to Connect Google Drive to Power BI (Detail Steps) 

Google spreadsheet integration 

 

Best Regards,
Community Support Team _ Eason

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.