Scheduled refresh failing due to missing gateway

[dan2036]

I have an SQL Server database feeding into a powerBI report. I publish it to powerbi.com and it works fine. However when I attempt to refresh it on PowerBI.com it fails. I also get the same failure when I try to schedule a refresh. 

I have the newest version of the on prem gateway (personal) installed and seemingly online. 

Any suggestions?

Thanks,

Dan

[v-yetao1-msft]

Hi @dan2036 

What is the connection mode you connect to SQL Server DB ? Import or Direct Query ? If you use DQ connection mode , you cannot use personal gateway ,because personal gateway only supports Import connection mode .

https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-personal-mode#on-premises-da...

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.