Forum Discussion
Solved
Automatic Refresh fails from PBI Service but PBI Desktop refresh works
Can some one please help me. I have a report that has been working for over 10 months now. Automatic refresh is set up and running. Database: 2 On Premise SQL servers Gateway: Azure On-Premises ...
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
Additional info: I created a duplicate of the report on PBI desktop. Published it and still refresh does not work on PBI service