Forum Discussion
[Unable to combine data]
Update.
Cautiously glad to report that the issue appears to be resolved. What seems to work is to remove reference to all queries and bring them all into one "monolithic" query. No compaints since that the query is referencing other queries or steps.
Thank you all for jumping in with tips and references. They were very helpful.
Cheers, and have a great weekend!
Don't see anything inherently wrong with this query. Is this the only query or are you trying to merge it with others?
For some more troubleshooting refer to Chris Webb's BI Blog: Troubleshooting Web Service Refresh Problems In Power BI With The Power Query Diagnostics Feature
Hi lbendlin,
Thanks for the link. I will review.
The query itself doesn't merge with any others. Downstream queries take the output of this query and separate the data into different groups. On occasion, on rare occasions, this query seems to go through (I think), as one of the downstream queries generate a similar error. I am not able to identify a pattern as to when the error is thrown by the first query vs. when the error comes out of the downstream query. Mostly the first one gives the error.
Thanks again for your response. I will review the link suggested.
Regards.