Forum Discussion

Cado_one's avatar
Cado_one
Icon for Resolver III rankResolver III
5 years ago
Solved

Unable to combine data - Please rebuild this data combination

Hi all,   I know there are already many topics regarding this issue but the common solution doesn't work in my case and I can't explain the reason. When refreshing on Power BI Desktop everything i...
Need Help
Tips and Tricks
  • Cado_one's avatar
    Cado_one
    5 years ago

    After some investigation, the solution was to put every stage used for the query into a single big query.

    It's not elegant but refresh is working this way..

waeltken's avatar
waeltken
Icon for Helper I rankHelper I
4 years ago

Cado_one,

 

can you please clarify: was the refresh not working in the PBI service or even on PBI desktop? I'm having the same issue, also with nested API calls, have deployed the solution outlined by Ken Puls but the PBI service still took issue with it. Am I understanding you correctly that in your solution you put everything back into a single query? Isn't  that exactly the opposite of Ken's solution? I wish that there were a better, more surgical way to diagnose the culprit in these errors. Does calling a customer "Transform File" Helper Query-type function trigger this? 

 

Regards,

 

 

Henrik

Cado_one's avatar
Cado_one
Icon for Resolver III rankResolver III
3 years ago

Hi waeltken 

 

Indeed the issue came from the Service only.

And yes I gathered every steps into a single query for the refresh to work fine in the Service.

I can't explain the reason but I confirm that it solved the problem.

 

Regards,

Cado