Forum Discussion
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
- v-lili6-msft
Community Support
hi, Anonymous
You may take a look at this post:
and this blog:
https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/
Best Regards,
Lin
- AnonymousNot applicable
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.