Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
Hi mark,
Thanks this works!
Used this query:
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |