Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Modifying JIRA content Pack

Hi Everyone! I'm trying to modify the original template of the JIRA content Pack to get more information about the issues of my organization. https://powerbi.microsoft.com/es-es/blog/explore-your...
Need Help
v-caliao-msft's avatar
v-caliao-msft
Microsoft Employee
9 years ago

Anonymous,

 

You can get more error message to make further analysis by using Fiddler. 

please capture the following logs while recreating the issue. 

 

Fiddler Trace

============

  1. Install Fiddler from http://www.telerik.com/download/fiddler/fiddler4 if not already done
  2. Launch fiddler, then click Tools > Fiddler Options
  3. Click the ‘HTTPS’ tab.
  4. Verify the options are set as shown in this screenshot:

111.jpg

 

5. If fiddler prompts you to trust their root certificates, then click ‘Yes’.

6. Then navigate to repro the problem while fiddler is capturing traffic.

7. After the trace is captured, go to File > uncheck box next to Capture Traffic

8. File > Save > All Sessions and post it here.

 

Regards,

Charlie Liao

    • miguel's avatar
      miguel
      Community Admin
      8 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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.