Forum Discussion
Solution SpecialistAPI data not refreshing in Service
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.
Solution SpecialistThanks 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.
Super UserDid you disable parallelism in the desktop?
- Aron_Moore
Hadn't changed the parallelism settings.
The desktop file is using settings of:
Global
Current File
- lbendlin
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.
- Aron_Moore
Did some research on the Function.InvokeAfter and modified my code.
It fully refreshed in desktop. Also made some visual changes to ensure the changes pushed up to the Service.
Still failing in the service with same error.
Thoughts?