Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 .
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.