Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
RickOShay
Frequent Visitor

How to stack datasets so that I can get Month over Month type of data?

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!

5 REPLIES 5
RickOShay
Frequent Visitor

Still looking for a way to do this. Would involving Azure provide any solution to what I am looking to do here?

RickOShay
Frequent Visitor

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.

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,

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.