I have an Excel Power Query in my sheet that connects to Oracle Database, when I start this query, I get the message that I reached the maximum simultaneous connections.
I asked at the Oracle Specialist and the maximum connection for one user is 10. Enlarging this number is no option.
The Oracle-specialist sees that there are nine and more connections become active when I start the query.
They see that Microsoft.Mashup creates these connections.
I disabled the option “Allow Data Preview to Download in The Background” but sometimes I still get the message “that the maximum number of connections is reached”.
Anyone an idea what the reason can be and how I can solved it.
Try not to use the existing Oracle connector, use the OleDB connector instead, as suggested in your other topic.