Refreshing data

[Alessandro-laba]

Hi all, 

I have a power bi desktop dashboard that is takind a set of data from the marketing platform Oracle Eloqua. To make this connection happen I am using a third party company and I import all the data. 

Since I have a lot of data when i hit refresh it usually take up to few hours. 

What i would like to do is to refresh only part of the data, let's say the last 6 months, and not all of them. I have seen something about Incremental refresh but it didn't work. Is there any other way to achieve this?

Thanks, 

Alessandro

[amitchandak]

@Alessandro-laba , I think incremental is the best option. there are alternatives like

Incremental Load

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

Others
https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
https://thinkaboutit.be/2020/02/how-do-i-implement-an-incremental-refresh-in-power-bi-free-or-pro/
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.nabler.com/articles/power-bi-data-refresh-and-scheduling/
https://www.fourmoo.com/2020/03/11/how-to-configure-incremental-refreshing-in-power-bi-with-datekey-...

[parry2k]

@Alessandro-laba can you filter at the source? Not sure what this 3rd party tools does, can you filter the data at tool level?