Forum Discussion
Ricardo_MSS
Helper II
Helper IIHelp applying Query and Relative path to avoid dynamic data source for Service refresh
Hi All, I've a function built to paginate through an API call. It works very well on the Desktop service but when trying to refresh on PBI Service the following error is displayed: ...
parry2k
Super User
Super UserRicardo_MSS if this works in desktop it means there is no issue with the code. I think you need to have gateway to refresh even though your data source is in cloud. In gateway settings, turn on "Learn more
Ricardo_MSSHelper II
Helper IIHi Parry thank you for respoding.
As you say the code runs well in Desktop and I am able to refresh online.
Regarding the Gateway that might not be the issue. This query was recently added to an existing report that worked well both online and in desktop. The report stopped refreshing online when this query was added.
When removed the report refreshed again online.