Using R to export then import data

[HayleyL]

Hi, 

I'm fairly new to Power Bi and have historically used Report Builder to report from my SQL Database (Housing Management System with no data warehouse). 

I have a gateway set up so the scheduled refresh aspect is fine. What I would like to do is export some of the data weekly (two columns and about 1200 rows), and then import it back with a date stamp or unique numerical value so I can then look at trends over a period of time. Each export will contain the same unique ID numbers with different values. 

From research I believe I can use R to export and them import the data, I can then use Time Series to use my historical and current figure to make predictions. 

I am just struggling to find any help with how to do all the steps together. 

Any help would be appreciated thank you. 

[mahoneypat · Accepted solution]

Do you get new records every week? Or are you exporting the same records to see changes? Ideally, your database would keep the change history that you could bring in directly. If not, you could use report builder to create a paginated report that you subscribe to weekly in csv format, and then use Power Automate to trigger off those emails and then save the files with a name with the date (probably to a SharePoint library).  You could then combine the files in Power Query.

Pat