Forum Discussion
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
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
3 Replies
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
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
