Weekly Report Refresh

[financemidlands]

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

[Anonymous]

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