Share
ReportI'm new to Power BI and looking for some help.
We have a system that reports real time data - e.g. records of sales per region, all on one sheet - and I want to collect daily real time data in a spreadsheet to create a record of this data overtime. I want this data to be recorded as one sheet per region. This system allows us to export that snapshot data to csv or Excel.
What I need is a spreadsheet with 45 sheets - one for each region and one sheet where I can import the snapshot data from the system.
I have gotten as far as ensuring that importing the snapshot data will automatically pull into each regional sheet. However, I want to pull this snapshot report daily and import it to the spreadsheet and have it automate populate the region sheets without losing the previous day's data.
Any tips??
All responses (
Answers (
312
