Evalution resulted in a stack verflow and cannot continue

[Wiene24]

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

[TomMartens · Accepted solution]

Hey,

maybe you can create a UNION statement like so:

SELECT * FROM table1

UNION ALL

SELECT * FROM table2

UNION ALL
SELECT * FROM table3

Doing 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

[Wiene24]

Hi mark,

Thanks this works!

Used this query: 

Samengesteld = UNION('GROOTBOEKMUTATIES KT';'GROOTBOEKMUTATIES KCD';'GROOTBOEKMUTATIES KLF';'GROOTBOEKMUTATIES KB')