Import of JIRA issues is failing

[Lipin]

We are trying to import the JIRA issues on to Power BI using the JIRA content pack and generate the dashboards. But this is failing with an error message "We couldn't Import the data" . Additional error information that I can gather from the error detail is "We found extra characters at the end of JSON input.. The exception was raised by the IDataReader interface."

Steps followed

1. Provided the JIRA issues link - "https://jira.companyname.com.au/issues/?jql=project%20%3D%20XXX"

2. Authentication selected as Basic and provided validd JIRA user name and password

3, Then tried connecting but failed  with the error message

JIRA instance  - Cloud

[Lipin]

Screenshot of the error message

 

[v-haibl-msft]

@Lipin

Did you provide the JIRA issues link in following fied?

You need to input the URL like https://sitename.atlassian.net to make the content pack connected properly. Could you please have a try with proper URL again?

Best Regards,
Herbert

[Lipin]

@v-haibl-msft - Thank you for your response.

Yes, I was providing the JIRA url but not in the exact format as provided in the sample (I was not providing the base link but the specific link to a "filtered" set of issues which was related to my specific project).

Now I have modified the url to https://jira.companyname.com.au and I am receiving a new error (screen shot attached). Is this an issue related to Admin access? 

[Anonymous]

Hello @Lipin,

I have modified the JIRA content pack for the same purpose, import the issues.
I add the following function:

let
    SearchIssue = () =>
    let 
        Source = Table.Buffer(FetchPages("", 500)),
        table = Table.ExpandRecordColumn(Source, "Column1", {"id"}, {"id"}),
        Search = (id) => 
        let
            Issue = Json.Document(Web.Contents(URL,[RelativePath="rest/api/2/issue/"&id]))
        in
            Issue,
        Output = Table.Buffer(Table.AddColumn(table, "incidencia",each Search([id])))
                                                    
    in
        Output  
in
    SearchIssue 

And It works on the desktop but when I publish on the Online Power BI service, the refresh fails and show me the error:

[Unable to combine data] Section1/Datos/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.

Have you found any solution?
Thanks!

[Lipin]

Hi @Anonymous -  Thank you for your response.

No I haven't found a solution yet and I am planning to raise a ticket with Microsoft support team.

When you edited the content pack then did you add (or replace) with the above mentioned function ? And did you do that for both "Fetch page" and "Fetch pages"? 

The error I am recieving is 

An error occurred in the ‘FetchPage’ query. DataFormat.Error: We found extra characters at the end of JSON input.
Details:
Value=
Position=8

[Lipin]

An update

I modified the url as this -  https://jira.companyname.com.au) but now I am continuously receiving the following error

An error occurred in the ‘FetchPage’ query. DataSource.Error: Web.Contents failed to get contents from

'https://jira.companyname.com.au/rest/api/2/search?maxResults=500&startAt=0' (502): Proxy Error
Details:
DataSourceKind=Web
DataSourcePath=https://jira.companyname.com.au/rest/api/2/search
Url=https://jira.companyname.com.au/rest/api/2/search?maxResults=500&startAt=0

Additional Information

When I Enter parameters for "Fetch Pages" or "Fetch page" step with a less number of pagesize , let's say 20, then I am able to pull data successfully with no error

[Anonymous]

Hi @Lipin!

My URL parameter is like yours (https://jira.companyname.com.au).
I didn't modify the functions of the JIRA content pack. I just added another function called "SearchIssue" which is the one I put.

After that I have created a query that call to the function "SearchIssue". Like this:

let
    Source = SearchIssue()
in
    Source

One question, when you said that: "When I Enter parameters for "Fetch Pages" or "Fetch page" step with a less number of pagesize , let's say 20, then I am able to pull data successfully with no error"
You are able to pull data at the desktop or online?

Greetings!

[Lipin]

Hi @Anonymous ...

Thank you for providing very useful information

Yes I published online and refreshed it successfully . I didn't receive any error. And please note that I didn't add the "SearchIssue" function that you have mentioned earlier.

I modified "FetchPage" function as given in red ( CHSD is specific to my project code so change accordingly) and this is to filter the query output from JIRA.

contents = Web.Contents(URL&"/rest/api/2/search?jql=project=CHSD",[Query = [maxResults= Text.From(300), startAt = Text.From(skipRows)]])

Additional Notes -  Tex.From(300) -  This was modified because I continue to receive the below error.

An error occurred in the ‘FetchPage’ query. DataSource.Error: Web.Contents failed to get contents from

'https://jira.companyname.com.au/rest/api/2/search?maxResults=500&startAt=0' (502): 

Hence I decided to hardcode the limit to "300" and I assume this may be because our company's Jira property is set with a max limit ('jira.search.views.default.max').

Chekc these Jira specific links (if you haven't before) and may be useful - 

• https://developer.atlassian.com/jiradev/jira-apis/jira-rest-apis/jira-rest-api-tutorials/jira-rest-api-example-query-issues
• https://community.atlassian.com/t5/Answers-Developer-Questions/REST-Client-get-all-issues-of-project/qaq-p/494826

[Anonymous]

Hi @Lipin!

Your way works fine but doesn't give the solution that I was looking for.
I need to get the information of the worklogs of every Issue but the solution that you give me doesn't show me the data.

I don't see a dynamic way to get the info of the worklogs.

Thanks!