How to perform Delta Load onto PowerBI Service where my source is SAP-BW On-premise?

[Anmolgan]

I am loading 3 years of data till the current month, whenever I refresh it took about 1hour 40minutes to refresh and generates dumps at the source which stops the process on the source server, I have 8 queries which contain 4 months of data each, how can I perform delta load only for current month?

[v-piga-msft]

Hi @Anmolgan ,

If you want to achieve Incremental refresh in power bi, you could try the Premium feature Incremental refresh.

You could have a good look at the document which introduces in details.

Best  Regards,

Cherry

[Anmolgan]

How can I test this feature out before moving to the Premium feature.

[Anonymous]

Well you can't test it, but it's supposed to be working in Premium.

[Anmolgan]

How will a customer move to the premium feature when they cant test the functionality out, or is there a money back guarantee by Microsoft if the feature will not work in SAP BW?

[Anonymous · Accepted solution]

Well, this question can be asked to any product that you can't test before buying (most of the softwares to be honest). You can't "test" SQL Server, Oracle DB, Windows, pretty much any Enterprise CRM on the market...

Specifications are contractual obligations (sort of). So if the software claims it can do it and you buy it and it doesn't you can request a refund.