Forum Discussion
Data Storage in Power BI Datamarts
It sounds like your June 2022 Excel file won't have data from May 2022, correct? In that case load from a folder with all your monthly Excel files (May 2022.xlsx, June 2022.xlsx etc.) to build up your data history.
In case what you want is to preserve the state of the data as it was in May 2022 then have the June 2022 version of those same rows, this is called snapshotting and is possible with regular dataflows using the underlying Azure Data Lake Storage Gen 2 folder, but on the other hand the dataflows generated in datamarts and saving to SQL don't generate snapshots.
It sounds like your June 2022 Excel file won't have data from May 2022, correct? In that case load from a folder with all your monthly Excel files (May 2022.xlsx, June 2022.xlsx etc.) to build up your data history.
In case what you want is to preserve the state of the data as it was in May 2022 then have the June 2022 version of those same rows, this is called snapshotting and is possible with regular dataflows using the underlying Azure Data Lake Storage Gen 2 folder, but on the other hand the dataflows generated in datamarts and saving to SQL don't generate snapshots.
