Forum Discussion
Scheduled refresh fails frequently(not always)
Hi, I have report on PowerBi service in a workspace which was scheduled to run every hour. Workspace used to be a premium capacity workspace, not anymore. Yet there are 23 slots for every hour in...
GilbertQ
Super User
Super UserHi there
From your error it would appear that the connectivity from your Gateway server to the SQL Server cannot connect.
I would log into the gateway server and verify that you can successfully connect to the SQL Server.
From your error it would appear that the connectivity from your Gateway server to the SQL Server cannot connect.
I would log into the gateway server and verify that you can successfully connect to the SQL Server.
I am certain that the gateway can successfully connect to the SQL Server.
The scheduled refresh completes successfully sometimes. Also, If I refresh the dataset manually it works all the time.
I have attached a screenshot of refresh history in my first message.