Power BI Data Source updating

[YellowDogAdmin]

I'm creating a report for our IT department.  Right now I am running a script that connects to the Graph API and pulls down User and Device details and saves them into a few different csv files.  It's not a ton of data, roughly about 1800 devices and 2000 users.

As I'm developing the report, this works just fine.  

My question is, what is the most efficient way to gather this data in production?  Ultimately I'd like the data to refresh automatically and on demand.  

I've read a little bit about Graph Data Connect and think that may work but that also costs money which sometimes can make management cringe.    

Is Data Connect the best option?  I assume I can export the data to the same csvs and have the Power BI report point to those csvs?

[Idrissshatila]

Hello @YellowDogAdmin ,

yes , you can export data and store them in csv in a folder and connect to folder. in power bi you work it in power query to append (union) the csvs so you can have them as one table.