Forum Discussion
API data not refreshing in Service
I have a model built on data from the JIRA Issues API.
It refreshes in the desktop app but it fails in the service saying"The column 'Column1' of the table wasn't found".
If I limit the number of calls to the API (temporarily modifying the query) to something small, like 3, it will refresh in the service.
The number of calls it should make is based on the number of records in JIRA and is currently around 250 calls.
Is there some sort of timeout or limit in the service that could cause the query to fail?
Is there something I can do to ensure all the data gets loaded?
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.
11 Replies
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.
Did you disable parallelism in the desktop?
