Forum Discussion
Modifying JIRA content Pack
Hi v-caliao-msft,
Here is the capture:
https://www.dropbox.com/s/pmyedrjwwa18hlc/Capture.saz?dl=0
I hope you can give me some advice.
Thanks!
Hey!
The fiddler tracer shows no records of any connection attempts to JIRA. It does show your email address and some other PII information to your Power BI host in north europe.
I believe that you're actually trying to find out why your query doesn't refresh on the cloud, rather than trying to trace your local pbix file. If this is the case, the first thing that you need to check is your query that has the name "AutoRemovedColumns 1" which is probably doing a reference to another query.
Referencing queries that come from APIs is usually a good idea in theory, but due to how the formula firewall pops up, is actually better to not use referencing at all and do everything in just one query. Try removing and simplifying your query to the point where there are no references and see if that makes your query refresh on the Power BI service.
PS: I'd delete that fiddler trace if I were you
Hi miguel,
I'm trying to find out why my query doesn't refreshs on the cloud, that's right.
In my local, the pbix file refresh whitout any problem but when I uploaded to the online service didn't work.
I don't have any query with the name "AutoRemovedColumns 1", in fact, I have been looking for information about and It looks like It's a generic name that shows always in this kind of error. I have seen many people's screenshots with this error that says that it doesn't have any query with the name "AutoRemovedColumns 1".I only have 1 query that references to 4 functions and 1 parameter. That could be the problem?
PS: Thanks for the advice, the trace It's deleted.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.