February 19, 2021
I get really often the message Ora-02391 Excedeed simultaneous Session per user Limit when I start a query thats connects to an Oracle Database.
I tried everything that i find on internet (query options setting, OLE-DB connection instead of Native) to solve this problem. Changing the query options helped but sometimes i still get this message. Changing the amount of connection per User is no solution, my company doesn't want to do this.
But now i get this message when i activated a Excel Power Query which only appends tables. (see Detail Append Query.png).
As you can see there is no attempt to connect to an Oracle Database.
The table that i want to append are the result of queries with an sql-query that makes connection to an Oracle Database.
The only cause that i could think of is that power query wants to refresh the tables when it executes the append instruction.
Is this so ?
Does anyone think of another possible reason.
Can someone help me to solve this.
In attachment you can also find printscreensof the option setting in Power Query.
November 8, 2013
Appending those 3 Collect Data queries will run each query, combining them is not an excel query if those queries are getting data from Oracle.
If you really want to combine excel data tables that are created by those queries, you have to load the output tables created by those queries back into PQ, there is a huge difference between combining queries and combining excel tables, even if those excel tables are created by the same queries.