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 perio...
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