Forum Discussion

JSiebrecht's avatar
JSiebrecht
Resolver I
5 years ago

Trigger full Refresh on Dataset with Incremental Refresh

I need a way to perform a "full" refresh of my 10 days window once a day with incremental refreshes in between. Background I have a very large datasource with billion of records in the future and...
Need Help
TomMartens's avatar
TomMartens
Super User
5 years ago

Hey JSiebrecht ,

 

my 1st idea is to an incremental refresh by using the xmla endpoint, but this requires some kind of Premium capacity: Advanced incremental refresh with the XMLA endpoint in Power BI - Power BI | Microsoft Docs

 

Another solution is to create a view on top of your data source, that filters the required data in advance. Then you can publish your dataset each day (or whenever you want) and perform an initial load, after that you can use the incremental load.

 

Hopefully, this requires some ideas on how to tackle your challenge.

 

Regards,

Tom

  • JSiebrecht's avatar
    JSiebrecht
    Resolver I
    5 years ago

    Hi TomMartens ,

    thanks for your input!
    My dataset is hosted in a P2 SKU Premium Capacity. If this gives options.
    To publish the dataset each day for the next X years, I don't hink that's a viable option for this kind of business process.