I have a OneDrive folder with a heap of CSVs. I have created a report in Power Bi Desktop which combines all these CSVs into a unified dataset.
I'd like to schedule jobs to update these CSVs on OneDrive, and have a report up in the Power BI service automatically refresh. I can do this with one CSV file, but googling around I cannot see how to do this with a folder full of CSVs.
Can anyone shed light on how to achieve this?
You can put all the csv files into one folder and upload the folder to onedrive, enable the synchronize between onedrive and your local. To refresh the dataset from multiple csvs, you should configure schedule refresh in power bi service, click dataset-> schedule refresh to configure the schedule interval.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.