Refresh when source data has changed

[simonroyjones]

Hi 

I have a number of reports that run from SQL Server tables that I maintain.

All my reports import the data and then they are synced through a gateway to online versions every night.

If I add a column to one of the source table then refresh the data in the desktop product, the refresh fails as the underlying data has changed.

Is there any way to get Power BI to see there is an additional column and add it to the available fields (maybe incremental refresh).

I'm not changing existing columns only adding new ones.

Thanks

Simon

[v-yuta-msft · Accepted solution]

@simonroyjones ,

I'm afraid power bi service will not add the new columns automatically, you need to open pbix and add the new column in query editor(advanced editor) and then publish to power bi service.

Community Support Team _ Jimmy Tao

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

[simonroyjones]

Thanks Jimmy

I have sort of solved the problem as well.

I was dropping the table in SQL and recreating it with a create table statement.

I found that if I add the field using 'Alter Table' and then refresh in Power BI, its fine with it.

Thanks for the advice 

Simon