Refresh Schedule failing

[MVAdmin]

Hi ,

We have a Power BI report consuming SharePoint List data published to PowerBI app scheduled for auto refresh for that data set. Below is the settings,

The problem we are facing is that when any data removed from data set(data removed from SP list),  scheduler is failing to refresh(power bi the "switch" to "Keep your data up to date" has been turning off automatically when scheduled refresh failed)

And shows the following error

Is this an expected behaviour? How do we avoid errors during SharePoint item delete.

Thanks in advance

[lbendlin]

That is expected behavior. Power BI service has no way of figuring out if your column changes have a deep impact on the data model or not.

Any structural change requires a re-publishing of the app.