Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Unable to combine data issue

Hi, I'm having an error trying to refresh a report on the service. The report has 2 queries, first is calling a token and the second one is using the token to retrive data from Jira.

The report is refreshed without problems on the desktop, but giving the following error on service: [Unable to combine data] Section1/RiskData/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination. Table: RiskData.

 

"Token" is the name of the query which gets the Token.

 

The code of the query:

let
Source = Web.Contents(#"Jira Environment", [Headers=[#"Content-Type"="application/json", Authorization="Bearer "& Token, Referer= User], RelativePath= #"API" & "?links=overview&rows=1000&filter="& #"Risk Filter"]),
Result = Json.Document(Source),
    foundIssues = Result[foundIssues],
    issues = foundIssues[issues],
    #"Converted to Table" = Record.ToTable(issues)
in
#"Converted to Table"

Please can someone help me to understand where is the issue?

 

Thanks!

2 Replies