Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Saving Data Weekly for a Power Bi Report

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.

Dataflow

3 Replies

  • rargyle's avatar
    rargyle
    Advocate II
    3 years ago

    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"])

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

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

  • v-luwang-msft's avatar
    v-luwang-msft
    Community Support
    3 years ago

    HI Anonymous ,

    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