Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Wiene24
Helper II
Helper II

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

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

2 REPLIES 2
TomMartens
Super User
Super User

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hi mark,

 

Thanks this works!

 

Used this query: 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.