Refresh history data count

[bzeeblitz]

I have data in sharepoint document library and its the datasource for my power bi report and i everyday upload new data excel file but in same path so thats how it gets refreshed in scheduled manner but im unable to see yesterday data in power bi scheduled report as the datasource contains daily new data from specified sharepoint path so how to display the history data in my power bi report as i now see only daily data which is current one so i want to see the history data.Kindly suggest

[Idrissshatila · Accepted solution]

Hello @bzeeblitz ,

so what I understood from you is that you every day replace the excel with the daily excel thus you're losing track of history.

what you can do is that you save these daily excel seperately and combine them in Power bi.

[bzeeblitz]

Additionally I store excel daily basis in teams channel folder based on date folder everyday  so shall we create report from this date folder and display a report of historical data

[bzeeblitz]

Though I have powerbi refreshed everyday from SharePoint library datasource and I display in report refresh scheduled but I'm not sure how to combine this powerbi report daily refresh into consolidated based on yesterday and today etc 

[bzeeblitz]

How to combine let's say I'm saving the daily excel in SharePoint library for each and everyday then how do I display history data into my powerbi report atleast last 2 days excel which I saved in different document library