check you MS Excel version and updates etc. Recently, we had an issue at one of our client site where Excel updates removed BI Integration. Luckily it was fixed with their IT Support team by downgrading some of the Excel updates. Speak to your IT Team. It is to do with Excel updates, unless issue is with DWH/ASD databases not updating, then this is something to fix in MS SQL permissions and service accounts.