SAP-BW BEx Query With Start and End Date Parameter in PowerBI?

[Anmolgan]

I have a SAP-BW BEx Query which contains a start and end date parameter, Since the data size is huge and I want to see 2 years of data, hence I am spliting each dataset of 4 Months in various queries and lastly appending them all together. I wanted to know how best we can achive when I will deploy this model to PowerBI Service? Can I build some kind of parameter here where I will define the start and end date and that will fetch me the results if yes how can I build something like this? Also if I have to updated each month and I will have to append each month from the desktop. 

Is there any better way to do this, so that I would not have to build report for each month and deploy?

[mwegener]

Hi @Anmolgan ,

maybe this option suits you.

Incremental refresh is generally available … and supported in Pro!

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-is-generally-available/