Forum Discussion

markmsc's avatar
markmsc
Resolver I
1 year ago
Solved

table refresh doesn't find changes but partition refresh does

Hello colleagues.  I have a Power BI premium model.  Some of the tables are quite large, but have the advantage that once a new day starts, much of the prior day's data can be removed.  We have a dai...
Need Help
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    1 year ago

    Hi markmsc ,
    Can you please share an update to your issue and let us know if you were able to resolve it by using azure pipeline-orchestrated XMLA refresh of the model, as this seems to be the best possible workaround currently available.

    Sharing an update and accepting the reply which may have helped you in the direction will surely help other community memebers who may experience the same error in the future.

    Thank you


SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
1 year ago

Hi markmsc ,

 

You can try this -

Schedule a partition refresh (instead of the full table) via the XMLA endpoint or Power Automate.

 

If feasible, consider switching to a delete + append strategy instead of flagging rows for deletion.

 

I hope it helps.

 

Thanks,

Sai Teja 

markmsc's avatar
markmsc
Resolver I
1 year ago

Hello SaiTejaTalasila and thank you for replying.

In the next couple of months, we will be moving to an Azure pipeline-orchestrated XMLA refresh of the model so will have the opportunity to do more granular things, in the spirit if your Power Automate suggestion, pretty soon.

 

As for delete + append, I assume you are referring to deleting the rows from the physical table?  If so, we do not want to delete the rows from the database, only from the model after the business day to which they apply has passed.  Hence the mark-for-delete strategy we have used.  And again, that was working fine for the past couple of months after we put it in; it only stopped working this week for some reason.  ðŸ¤”