Forum Discussion
Modifying JIRA content Pack
depending on how those 4 functions interact with that query, that could be the problem. If it's doing another reference, or trying to combine data sources, then it might give you errors on the Power BI service.
Power BI Desktop and the Power BI have disparity. Some things might work nicely on the Dekstop, but not on the cloud and its usually due to Privacy Levels that provoke the Formula.Firewall.
There's no simple solution to this. You'd need to deconstruct your query and start testing by pieces to see if it refreshes on the cloud. My suggestion is to start with your initial query, upload it to the service and see if it refreshes. Then add 1 new function to that query and see if it refreshes on the cloud. Keep doing that last part until you hit the error and you'll find what function is the culprit of the problem
I have just deconstructed the query and the problem comes from the last function that I added to the original JIRA contet Pack.
The function called "SearchIssues" that I put at the begining of the post, gets the info from every issue.
I need worklogs information from every issue and I think the only way is by bringing a list of all the issues in my JIRA and after this, make a call to the JIRA API for each of the issues.
The original script from Jira content pack gives me the list of issues and after this I added the function "SearchIssues" which should bring me the data for each issue. Here is where the problem comes, I think that It's not possible mix in a table the list of issues from the first call and the info from the next calls to every of them.