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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Incremental refresh options SAP BW connector with date in BW or Hana JJ.MM.AAAA

Hello, I wanted to do an incremental refresh for a sap BW or hana connection with dates of type DD.MM.AAAA and [text].[aaaammdd], I did a conversion with language M, and I published the report in a premium workspace, but the incremental refresh takes longer than the normal refresh, you find my formula M used for parameters filter,
you will find the screen captures,
Thank you for your help,Incrémentiel-1.PNGInkedIncrémentiel-2.jpgInkedIncrémentiel-3.jpgInkedIncrémentiel-4.jpgIncrémentiel-5.PNG

 
 
 
2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @Anonymous ,

 

The reason that it possibly takes longer is due to the fact that in order to complete an incremental refresh there are other things happening in order to make this happen, such as moving current partitions, processing previous partitions if they need to be merged, creating new partitions and then processing new partitions.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Anonymous
Not applicable

Hello,

Thank you for your return,
the incremental refresh works well with SAP BW and Hana, dates of type DD.MM.YYYY breaks a problem, transformation from text to date:time breaks a problem

Thanks,

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.