Forum Discussion
Incremental Refresh
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
4 Replies
Hi Mumin192
check here https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters
Pay attention, dataset is Semantic Model now
Thanks for your ansewr
For some reason, I can't find the parameterseven though I set it up before publishing
Any ideas?
ThanksHi Mumin192 ,
It might be due to data Please refer this -
I hope it will be helpful.
Thanks,
Sai Teja
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
