error handling on the data fetched from sharepoint online in power bi

[Anonymous]

Hi Team,

I have a query regarding pro active error handling in Power bi.  we have a sharepoint list with a look up to other list. Now we have a situation where the record has been deleted from main list , so the other list value has returned error record  in power bi as the look up value is not available. This led to the failure of schedule refresh job.

So , my query is eventhough there is a backend deletion activity from sharepoint side, is there any possible way to pro actively detect the errors and refresh the data successfully. Please let me know if there is one.

Thanks in advance.

Regards,

Sivapratap.

[v-shex-msft]

Hi  @Anonymous,

You can refer to below blogs which about error handling of power query:

Error-handling in Power Query

Handling Data Source Errors In Power Query

Regards,

Xiaoxin Sheng