Saving Data Weekly for a Power Bi Report

[pcarmen]

Hi,

Appologies if this has been covered and I havent been able to frame my searches correctly.

We are trying to run a weekly report with power bi. Previously we have saved a new pbix file each week. However I would like to manage one report with a new dataset saved each week. Bonus points for us able to interact with the data sets at the report level and load in each week based on a parameter in the report.

I am not really sure how to start (each report has 10+ data inputs). 

Any advice or links would be greatly appreciated.

[rargyle]

I've set up a "snapshot" style data dump where I have a report that when it refreshes, writes a CSV file to a SharePoint location, with a year-week number in the filename. The code for this report (there are no visuals needed) uses some R script to write to a local machine, so you need a Personal Gateway running on it. 

Then you could have a separate report that reads the CSV files in the SharePoint location and loads the correct one(s) according to your parameter.

If this sounds like a solution to your issue, once you have installed R Open, the R code you will need is:

R.Execute("# 'dataset' holds the input data for this script#(lf)write.csv(dataset, file = "C:/LocalFilePathToSharePointSync/Snapshot_Week-" & Number.ToText(CurrentWeek) & ".csv"")",[dataset=#"Previous Step"])

[v-luwang-msft]

HI @pcarmen ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[lbendlin]

Power BI has no memory. You need to do the data storage in the upstream system.