Yes, there is a way to automatically refresh the data in Power BI Desktop without having to manually click the refresh button. One option is to use the Power BI Personal Gateway, which allows you to schedule automatic refreshes of your data from a variety of data sources, including CSV files.
https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode
To use the Power BI Personal Gateway for automatic refresh, follow these steps:
Install the Power BI Personal Gateway on the computer where your CSV file is located. You can download the gateway from the Power BI website.
In Power BI Desktop, go to the "Home" tab and click on "Transform Data" to open Power Query.
In Power Query, connect to your CSV file and perform any necessary data transformations.
Click on "Close & Apply" to close Power Query and return to Power BI Desktop.
Go to the "File" menu and select "Options and settings" > "Options".
Select "Data Load" from the left-hand menu.
Under "Data Load", select "Enable load" and "Include in report refresh".
Under "Data Load", select "Refresh data when opening the file".
Under "Data Load", select "Refresh every" and set the frequency at which you want the data to be refreshed.
Click on "OK" to save your changes.
Go to the "Home" tab and click on "Publish" to publish your report to the Power BI service.
In the Power BI service, go to the "Datasets" tab and select your dataset.
Click on "Settings" and select "Scheduled refresh".
Set up a refresh schedule for your dataset, using the same frequency as you set in Power BI Desktop.
Click on "Apply" to save your changes.
Once you have set up the Power BI Personal Gateway and scheduled refresh for your dataset, your CSV data will be automatically refreshed on the schedule you have specified.
