the on-premises data gateway installation has failed

Hi there,   Please help in connecting gateway to my power bi service to schedule auto refresh to my sql server.   thanks in advance.