Incremental Refresh on Datamart

[Yogesh_NMH]

Hi everyone,

My Power BI Pro licence has recently been upgraded to Premium Per User and I wanted to test the Datamart features.

1. Created the datamart: OK
2. Connected to my SQL Server datasource: OK
3. Imported one full table as a test: OK

However, when I try to implement Incremental Refresh, it stays on "Wrapping things up" for quite a long time and then throws the following error:

I have even recreated a Clustered Index on my datetime field in the table on which I wanted to implement Incremental Refresh and re-tested. Same error.

Thanks in advance for your assistance.

Kind regards,

Yogesh

[v-yueyunzh-msft · Accepted solution]

Hi , @Yogesh_NMH 

According to my search for your issue on the internal issue site, this is a known bug confirmed by the product group, and a fix plan is on the agenda, but no detailed expected fix date has been given, iCM number: 325752870

If there are any expected fixes or fixes announced, I will update you here, thank you for your time and understanding!

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[salty]

Has this bug been fixed?  It seems like it works with smaller tables, but not on large tables where we really need it.  My 500K table seems fine, the 28MM row table just never finishes an incremental refresh.  

[Yogesh_NMH]

Hi @v-yueyunzh-msft 

Many thanks for your reply.

Hopefully a solution is found as early as the first quarter of 2023.

Have a great day & take care.

Kind regards,

Yogesh