Forum Discussion
Automatic Refresh fails from PBI Service but PBI Desktop refresh works
This has been fixed although I can't still explain why the error came about and how the solution fixed it.
Solution: Added a new gateway connectionGo to Semantic model --> Schedule refresh -->> Gateway and cloud connections --> Add to Gateway
In the new window, I filled all required info as it was a new connection.
After that refreshed my dataset it worked.
This is weird because the old gateway connection is there and still works for other reports connecting to the same DB using the same on-premise gateway
This has been fixed although I can't still explain why the error came about and how the solution fixed it.
Solution: Added a new gateway connection
Go to Semantic model --> Schedule refresh -->> Gateway and cloud connections --> Add to Gateway
In the new window, I filled all required info as it was a new connection.
After that refreshed my dataset it worked.
This is weird because the old gateway connection is there and still works for other reports connecting to the same DB using the same on-premise gateway