File CSV in google drive - that need update daily

[schjair]

I need to connect a database with the CSV extension that is on Google Drive and it is updated daily on Power BI.
I have already carried out tests with the Google Spreadsheets connector without success.
Could you suggest me how to proceed with this connection?

Note are the administrator of the google drive folder and the file is automatically updated in google drive.

[Anonymous · Accepted solution]

Hi @schjair ,

If you want to connect to  CSV on Google Drive, please try to use its URL:

If it's on Desktop, you'll need to do a manual refresh of the data every day, or you can publish to Service to try to refresh it automatically:
Data refresh in Power BI - Power BI | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.