SharePoint - Bypass APM for Office and PowerBI

After implementing APM on SharePoint, users are unable to edit documents directly in Office or PowerBI.

Workaround is to bypass APM when the User Agent string matches "microsoft office" for all Mirosoft Office applications and also bypass APM when the User Agent string matches "microsoft.data.mashup" for the PowerBI desktop client using the below iRule.

Included bypass for the url "/_vti_pvt/service.cnf" to allow PowerBI to connect to SharePoint Lists.

priority 1
when HTTP_REQUEST {
    set is_disabled 0
    switch -glob [string tolower [HTTP::header "User-Agent"]] {
        "*microsoft.data.mashup*" {
            set is_disabled 1
            set path [HTTP::path]
            ACCESS::disable
            HTTP::path _disable-$path
            pool /Common/sp2013_pool
        }
        "*microsoft office*" {
            set is_disabled 1
            set path [HTTP::path]
            ACCESS::disable
            HTTP::path _disable-$path
            pool /Common/sp2013_ext_pool
        }
    }
    switch -glob [string tolower [HTTP::path]] {
        "/_vti_pvt/service.cnf" {
            set is_disabled 1
            set path [HTTP::path]
            ACCESS::disable
            HTTP::path _disable-$path
            pool /Common/sp2013_pool
        }
    }

}

when HTTP_REQUEST_RELEASE {
    if { [info exists is_disabled] && $is_disabled == 0 } { return }
    if { [info exists path] } {
        HTTP::path $path
        unset is_disabled
        unset path
    }
}