Incremental Refresh

[Mumin192]

Hello,

I have a large dataset that I can't refresh

I set up the incremental refresh, but Power Bi Service couldn't load it for the 1st time

Is there a solution to increase the load amount periodically, or the archeive amount or something?

for example if the data for the last 4 months, I would either load Aug and Sep, then increase amount, or load Nov then Oct and backwards

I couldn't find where I can change parameters inside the Service, I only find it in desktop version

Any other solution?

Thanks

[pallavi_r]

Hi @Mumin192 ,

Can you try loading data using XMLA endpoint in SSMS. Here data will be available in partitions - monthly/yearly, which can be refreshed partition wise. Please see the below link if it can solve your issue.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-xmla

https://radacad.com/what-is-the-xmla-endpoint-for-power-bi-and-why-should-i-care

Thanks,

Pallavi

[az38]

Hi @Mumin192 

check here https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters

Pay attention, dataset is Semantic Model now

[Mumin192]

Thanks for your ansewr
For some reason, I can't find the parameters

even though I set it up before publishing

Any ideas?

Thanks

[SaiTejaTalasila]

Hi @Mumin192 ,

It might be due to data Please refer this -

https://biinsight.com/microsoft-fabric-troubleshooting-query-parameters-in-published-semantic-models...

I hope it will be helpful.

Thanks,

Sai Teja