cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Microsoft
Microsoft

Query on incremental refresh

Hi All,

My Database has one month of rolling data.Can I achieve to keep 3 months data in power bi by using incremental refresh ??

 

 

Regards,

Suman

10 REPLIES 10
Super User II
Super User II

Hi @sumchak,

 

yes, that should be possible.

 

Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh https://blog.crossjoin.co.uk/category/incremental-refresh/

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

My data soruce having 1 month  of roling data. I have implemented the incremental refresh to store 3 month data and refresh data for 15 days. But during refresh its store 1month of the data only. unable to understand is anything I am missing.

Hi @sumchak,

 

do you use the Power BI service?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

Yes , I am fetching data from log analytics where we have only one month of data.

Hi @sumchak,

 

can you share some screenshots?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

s1.pngs2.jpgs3.jpgs4.jpg

Hi @sumchak ,

 

looks good to me. I would have now expected the amount of data to grow with every refresh in the Power BI Service.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

But its not working as expected ..Can it be because the of the Soft delete or Hard delete in the source DB?

Hi @sumchak ,

 

the Detect data changes column should not be the same column used to partition the data.

 

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh#detect-data-chan...

Detect data change.png

Take a look at this video.

Power BI Incremental Refresh - Understanding Detect Data Changes

https://www.youtube.com/watch?v=JsJWBr1_ktQ

 

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
"Get the most out of data, with Power BI."
twitter - LinkedIn - YouTube - website

The implementation was correct but there are different sets of reasons why it wasn't working. 
Thanks for your help.


Conclusion: Incremental refresh shouldn't be implemented if the data source doesn't support the foldable query feature.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors