Preventing Power BI Semantic Model Refresh Failure

[Liam2468]

Hello Everyone,

As you probably know, it takes only one table in a Power BI semantic model to fail to refresh in order for the entire semantic model to refresh. Is there a way to prevent this from happening? I am already aware that the "Include in report refresh" option can be unchecked for tables in the Power Query Editor window. However, when more than one table fails to refresh at a time, the process for identifying which ones need the refresh disabled becomes tedious because the error message usually only mentions one table at a time. I am also aware that there is a way to do error handling but that is also for individual tables. To this for every table in a semantic model would be tedious. I am curious to hear your thoughts. Thank you in advance.

Regards,

Liam

[v-sathmakuri]

Hi @Liam2468 ,

I hope the information provided is helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @Liam2468 ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you!!

[v-sathmakuri]

Hi @Liam2468 ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[lbendlin · Accepted solution]

It is up to you to decide if they all need to refresh successfully, or if they can all be refreshed individually without impacting other tables.

The Enhanced Refresh API allows you to selectively refresh individual tables and even partitions (if you use incremental refresh)

Enhanced refresh with the Power BI REST API - Power BI | Microsoft Learn