Forum Discussion
How can I avoid error - [Unable to combine data]...references other queries or steps...Please rebuil
Hey when you published to pbi service, what kind of configuration do you have? Are you able to show us? How many data sources have you connected in this report? all web api connetion?
- julesdude4 years agoPost Partisan
Hi Anonymous lbendlin
It's all web api connection to one system. There is no gateway involved, if that's what you mean. I'm connecting Anonymously and the privacy level is Organizational.
Each query call works a bit like this:
0a Get a token for the session to be used with the below queries:
let loginData = [email=V_E,password=V_P, featureId= "55"], loginOptions = [ Headers = [ #"V-Locale"= "en-gb", #"V-TimeZone"= "Europe/London", #"C-Type"="application/json;charset=UTF-8", #"V-Feature"="6" ], RelativePath = "session", Content = Json.FromValue(loginData) ], Get_Token = Json.Document(Web.Contents(V_loginUrl, loginOptions),9999)[token] in Get_TokenThen the queries below use the token acquired above for their calls
(Build table 1)
1a Get headers for the table id, tranpose it and remove 8 bottom rows to keep just row 11b Get content for the table id
1c Merge a and b together to form one table and promote first row as header row
That wasn't quite working at first and I got the above error message. Scouting around on this forum searching for those with a similar error, one solution worked for a guy by consolidating all the queries into one, so I merged the above into one bg query which did work.
However, I need the processes x 6 to bring in 6 tables into the report for analysis. When I repeated the steps that's when I got the above error message again. So I know it works for a single table, but seems to knock over at nth table.
So I don't know what is going on.