Forum Discussion
Evalution resulted in a stack verflow and cannot continue
Hi,
I was trying to combine 4 of the same tables (different administrative companies) from Multivers but I got the following error:
Evalution resulted in a stack verflow and cannot continue
I tried to find an error in the diagnostic tracking file, but couldn't find anything usefull.
One of the tables has over 5,4 million rows. The other 3 have just a couple thousand.
I even have filtered the rows down to 3,4 million.
The tables have all the same columns.
The database is created with an ODBC-link.
I have tried to combine the query as a new table and adding the three small ones to the big one. Both give the same problem.
Can anyone help with this problem?
Kind regards,
Tim Wijnen
Hey,
maybe you can create a UNION statement like so:
SELECT * FROM table1
UNION ALL
SELECT * FROM table2
UNION ALL
SELECT * FROM table3Doing this, your database server will do the work, and not your desktop machine. This article will provide some guidance: https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces
Regards,
Tom
2 Replies
Hey,
maybe you can create a UNION statement like so:
SELECT * FROM table1
UNION ALL
SELECT * FROM table2
UNION ALL
SELECT * FROM table3Doing this, your database server will do the work, and not your desktop machine. This article will provide some guidance: https://docs.microsoft.com/en-us/power-bi/desktop-connect-using-generic-interfaces
Regards,
Tom
Hi mark,
Thanks this works!
Used this query:
Samengesteld = UNION('GROOTBOEKMUTATIES KT';'GROOTBOEKMUTATIES KCD';'GROOTBOEKMUTATIES KLF';'GROOTBOEKMUTATIES KB')
