Forum Discussion
Solved
Create a Dynamic Table which extracts value from the source
Hey Guys, I am using an excel report which is emailed to my Outlook account on a daily basis. I can extract the table in the excel report in PowerBI. However, I want PowerBI to store the previo...
Without incremental refresh Power Bi isn't persistant. I.e. you will need to load all previous data again for each day.
That being said, if you have all the previous Excel sheets in a single folder you can combine it into 1 dataset.
To do this
- Create a folder connection to the location of your ExcelSheets, then in the first column click the combine button.
- Do a group by using the Source.Name as the key in the group, with
- Max of Date Aggregate
- Sum of Amount Aggregate
- Finally, simply reemove the Source.Name column
Just to clarify in the above post:
The table is not displayed properly. All the tables in the original post are two Column Table with Date in First Coloum and amount appearing after the date in the 2nd Column.
Without incremental refresh Power Bi isn't persistant. I.e. you will need to load all previous data again for each day.
That being said, if you have all the previous Excel sheets in a single folder you can combine it into 1 dataset.
To do this
- Create a folder connection to the location of your ExcelSheets, then in the first column click the combine button.
- Do a group by using the Source.Name as the key in the group, with
- Max of Date Aggregate
- Sum of Amount Aggregate
- Finally, simply reemove the Source.Name column