Unable to combine data issue

[Anonymous]

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!

[v-lili6-msft]

hi, @Anonymous 

You may take a look at this post:

https://community.powerbi.com/t5/Service/Unable-to-combine-data-Please-rebuild-this-data-combination/td-p/121525

and this blog:

https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

Best Regards,

Lin

[Anonymous]

Thank you Lin, but in the post you sent the solution was set all parameters with the attribute "Any Value" and I did it so now all the parameters I used are "Any Value". Then the blog suggest to use separate queries, the problem for me is: I need a query to get a token and use it in another query to get the data. So I don't know what to do as workaround to avoid the error in the scheduled refresh 😞

If you need more details about the code I can provide it.