Forum Discussion
OLE DB Connection To Oracle Failing
Thanks Gao,
I had already tried all of the above suggestions.
In the end I gave up with OLE DB and re-tackled the slow speed of the standard connector.
I found that the issue is the Fetchsize. The Oracle client's default is too small for analytical type data extracts, but Power Bi doesn't overide this with a better value in its provided connector.
I ended up having to modify the registry (Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\4.122.19.1) and adding Fetchsize = 4194304 (trial for a suitable value).
The other solution would have been to modify Microsoft.Mashup.Container.NetFX45.exe.config, however for whatever reason, I can't modify anything in my Power Bi install on my machine using local admin (I can modify the registry however, go figure). This would probably be preferable. The response from Adamboer in the following post was useful input but without access to modify the file it wasn't going to help.
Thanks Gao,
I had already tried all of the above suggestions.
In the end I gave up with OLE DB and re-tackled the slow speed of the standard connector.
I found that the issue is the Fetchsize. The Oracle client's default is too small for analytical type data extracts, but Power Bi doesn't overide this with a better value in its provided connector.
I ended up having to modify the registry (Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ODP.NET\4.122.19.1) and adding Fetchsize = 4194304 (trial for a suitable value).
The other solution would have been to modify Microsoft.Mashup.Container.NetFX45.exe.config, however for whatever reason, I can't modify anything in my Power Bi install on my machine using local admin (I can modify the registry however, go figure). This would probably be preferable. The response from Adamboer in the following post was useful input but without access to modify the file it wasn't going to help.