I'm sorry if this question is ham fisted, I'm a bit confused by the differences between service and desktop, and how they work together.
The gist: I have files on a network drive (mostly csv and excel) and I have a report mostly done on powerbi desktop. The data that goes into this report updates a few times a day. This is a forecasting / system stats report that my team makes decisions on during two meetings per day, and sometimes more.
Ideally I want a report or dashboard (still foggy on the difference) that can be updated automatically at a few key times, which means pulling this data from various places on our network, none of which are currently one drive or sharepoint.
So my question is how do I need to do this? Do I need a server side script to put these files in a location on a schedule? Since there is a good bit of cleaning and formatting done by power query how does that work? Do I just need to have a desktop flow that updates and publishes the report?
I've tried searching, and youtube, and I am just not finding the guidance I need, so I'm probably barking up the wrong tree in terms of keywords to search for. Any help would be greatly appreciated.
