I once commented to my boss about how I would love a job where I could take my dog to work. She told me to try it. That was over two decades ago and I have had dogs at work ever since.
A positive experience is a must, or you may not get permission to bring your dog again.