Analyze in Excel is disabled for on premises Analysis Services databases in DirectQuery. Please contact your tenant admin ...