Excel automation using power bi and sql server

Create excel pivot table and measurements
add Data source to sql server and power bi
write excel filter for auto cell updates from data sources