Samuel McGhee, 56, was one of 10 people killed when a police helicopter crashed through the roof of the Glasgow pub two weeks ago.
Family and friends of Mr McGhee gathered at a service at St Margaret Mary's Church in the Castlemilk area of the city today.
A kilted piper played Amazing Grace at the church door as the hearse arrived.
Among the congregation were Mr McGhee's son and daughter by his late partner Liz - Michael, 25, and Kerry, 20 - and his son from a previous relationship, James Diver, 33.
The two sons embraced each other as they helped to carry their father's coffin into the church. Mr McGhee's daughter wept as she entered the service carrying a red rose.
Chief Superintendent Barry McEwan, of Police Scotland, was among the mourners, along with Glasgow Lord Provost Sadie Docherty and Glasgow City Council leader Gordon Matheson.
A white floral tribute reading "Dad" was placed outside the church door.
Before his funeral, his family paid tribute, saying: "We'd like to start by thanking the tireless efforts of the emergency services and the ordinary people of Glasgow on Friday night. Without them we're sure a lot more people would have lost their lives.
"It's been an incredibly difficult time for us and everyone involved with the tragedy, but the support from family, friends and the people of Glasgow has been overwhelming.
"Special thanks must be extended to the police liaison officers, Anderson Maguire funeral directors and the local Castlemilk community, in particular the people of Holmbyre, who have been unbelievably helpful and generous.
"Our father was a dedicated partner to our late mother and a dedicated parent to his children, who was just beginning to get his life back on track after the loss of our mum.
"As you can imagine this has been an intensely painful experience for us but we're strengthened by the knowledge that he passed away a happy man, among friends at a place he loved.
"We kindly ask for our privacy to be respected at this moment in time."
A service will be held at the city's Linn Crematorium after the church.