I'm trying to pull data from Azure SQL Server and from MySQL (Amazon RDS) via On-Premise gateway.
Everything works fine if I do it separately but the moment I try to append those tables the gateway gives me that error:
Both tables have the same columns and same data types.
I have tried to play with privacy levels too as said in some other topics but didn't work.
We have the latest gateway version installed.
The Operation causing problems:
Looking at the gatewayInfo logs we found that:
On the other side, at the gatewayError logs:
If I Append only the tables from Azure it works fine too.
I am missing something? Is there anything we can do to solve the problem from the PowerBI before start playing with IP permissions and stuff like that?
I think I can solve it with UNION in DAX but those tables are both pretty large and I don't think it is my best option.