direct query in power bi desktop

[Anonymous]

Hi

When SQL DB source is connected direct query to power bi desktop . After that any changes like (DML) occur in SQL DB it automatically refresh in power bi desktop or we need to do manually refresh it.

Thanks

sreenivasa

[v-caliao-msft · Accepted solution]

@Anonymous,

1. Change table name. Will get a error when refresh data.
2. Change column name. We need to refresh it manually. 
3. Change column data type. We need to refresh it manually. 
   
4. Add Column. We need to refresh it manually. 

Regards,

Charlie Liao