Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
50 | |
18 | |
16 | |
16 | |
8 |