Forum Discussion
API data not refreshing in Service
- 2 years ago
That'll do it. This setting is ignored in the service, and the service will always try to run queries in parallel.
One way to prevent that is to use the Function.InvokeAfter trick.
Hi Aron_Moore
There could be a limit on the JIRA side.
If you change your code to go from 1000 to 3 and let it run through does it all complete successfully?
If it does I would then up the number until it fails and then go one back?
Thanks for the reply.
The query runs fully in the desktop tool so I don't think there is a number of calls limit for our JIRA.
I could try to find the number of calls Power BI service can make before failing, but that is going to be less than the number of calls needed to get the whole of the data.
- lbendlin2 years ago
Super User
Did you disable parallelism in the desktop?
- Aron_Moore2 years ago
Solution Specialist
Hadn't changed the parallelism settings.
The desktop file is using settings of:
Global
Current File
- lbendlin2 years ago
Super User
That'll do it. This setting is ignored in the service, and the service will always try to run queries in parallel.
One way to prevent that is to use the Function.InvokeAfter trick.