Forum Discussion

financemidlands's avatar
financemidlands
New Member
6 years ago

Weekly Report Refresh

Hi,

We have a sales report that we currently use in excel. The data is relatively large (10,000+rows by 30columns) and will only grow as new enquiries come in. 

I have imported last weeks file into Power BI and cretaed a report and published it. It works great but now i want to put this weeks data in to Power BI.

 

When i create a new dataset i cannot update the current report(maybe i am missing something simple). I have to either create a new report or save over the datatset file i used to create teh report. 

 

Is there anyway i can just import the new sales file and link it to a report tempate and we can do this weekly. 

 

Thank you

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    I think the best way is to make one import file, like a csv.