[Beginner] I receive a regular spreadsheet from client, possible to add to existing visualizations?

[Csm1th11]

Hi,

I regularly receive a large amount of data from a client, with the same format except for change in time period.

Is it possible to set up the visualizations that I would like, and simply link in the new spreadsheet each week? 

Right now I build the visualizations again every time.

Thank you in advance, any help is appreciated.

[Anonymous · Accepted solution]

Hi @Csm1th11

Yes, this is possible.

You can import the Excel file into PBI Desktop, build your Reports and refresh them each time the customers sends a new file.

Microsoft has a good article about this: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-excel-workbook-files/

[Csm1th11]

Thank you!