Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
Hi,
I'm very new to Power BI. I have built a report in another system that generates an excel output and have that going into Power BI as a dataset. This report provides current daily information (for example daily balances). Everytime a refresh occurs, it appears that it basically just overrides the existing data with the most current data, which is good, but what I want to do is have that data stack so that eventually I could generate reports to compare month over month, year over year etc...
How do I get data coming in to be retained so that I can keep a history and build historical data rather than just override with fresh daily data?
Thanks!
Still looking for a way to do this. Would involving Azure provide any solution to what I am looking to do here?
Hi,
I posted this awhile ago and didn't really get any information that would help me do what I am looking for. If I have a report that refreshes each day with new data, is there any way that I have have that data archive into PowerBI? For example if data refreshed today, but I wanted to pull up data from the begining of the month (03/01/2023) how would I do that?
Thanks,
I'm still looking for a solid answer to this question, as I have not found one that provides a clear answer if PowerBI can do this.
@RickOShay , check if DAX append method can help
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
Hi,
Thanks. I will take a look at those resources you provided.
Am I correct in thinking that Incremental Refresh does what I am requesting? After doing some research earlier, I originally thought that it did, but then I thought I read somehwere else that it was primarily used in instances where you have a very large report and only want to refresh from parts of the data rather than a bunch of data that might remain static.
Thanks,
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!