I am having similar issues. I resorted to placing all information in one table using power query. Not ideal but it's the one that's working right now.
I hope there is an answer to this issue.