none
Power Query and Oracle FetchSize RRS feed

  • Question

  • Is there a way to alter the connection string to Oracle to add the extended parameter "FetchSize"?
    Tuesday, July 28, 2015 11:26 PM

Answers

  • Unfortunately, currently there is no way to alter the connection string to Oracle to add the extended parameter "FetchSize".

    Thanks,

    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, August 4, 2015 12:33 AM
  • There is a workaround, which is to use ODBC with an Oracle driver instead of the "built-in" Oracle functionality. Then you can specify whichever connection string parameters you like. It's possible that this will reduce functionality from what you get with Oracle.Database.
    Tuesday, August 4, 2015 3:27 AM

All replies

  • Brave man.

    I don't have an Oracle DB to test with, but I'm assuming that you have gone into Advanced View in Power Query editor and checked there, what does that connection string look like, can you post the top part of your M code?

    Thursday, July 30, 2015 10:57 PM
  • Unfortunately, currently there is no way to alter the connection string to Oracle to add the extended parameter "FetchSize".

    Thanks,

    Kati


    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, August 4, 2015 12:33 AM
  • There is a workaround, which is to use ODBC with an Oracle driver instead of the "built-in" Oracle functionality. Then you can specify whichever connection string parameters you like. It's possible that this will reduce functionality from what you get with Oracle.Database.
    Tuesday, August 4, 2015 3:27 AM