CSV file refresh from Google Drive

[smjoshi]

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

[GilbertQ]

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...

[smjoshi]

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

[v-easonf-msft · 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