
Announcements
Hi!
I am trying to pull data from a shared FTP folder into power bi. The reports in the folder are updated every hour by someone. Power bi is unable to pull it in with the schedule pull. I tried creating a batch file that when opened, it deletes all the files in a new folder that I created and copies everything from the FTP folder and pastes it in the new folder. And then I created a power automate desktop flow tat runs every hour to open that folder and refresh the power bi dataset.
My only problem is, the batch file does not open when I am logged off after work even with the power automate desktop flow. Is there a work around for this?
Thank you!!