Power BI
CompletedFaster oracle database connection. The existing one is slow compared to the SQL Server one.
Ken Lewen on 30 Nov 2015 20:26:15
The existing oracle data source is extremely slow. I even installed the latest oracle drivers from oracle and that only saw a marginal improvement in speed. My other oracle apps using the same connector are very fast, but Power BI is extremely slow.
- Comments (24)
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Any updates on this
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
My clients struggles with poor performance of PBI over their Oracles databases. Hundreds of thousands of rows. Takes hours to load, even after testing all possibilities read on various post/forums. Even if it's a killer apps, hard for them to move to PBI. Hope to see a fix soon...
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Interested in an update as well. Oracle connections are still extremely slow.
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Do we have any update or alternative solution for this issue?
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
It feels like it is getting worse, not better. Can we move this up the priority list?
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Hello, any update? I have the same issue... ='(
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Hi, Even for me..when I extract the data from oracle for few of tha tables,its loading very slow.like 50 to 60 rows per 5 sec...
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
ORACLE data load is still SLOW like snail.. downloading data from SQL client works much faster.. any solution or a workaround? don't want to download plaintext and load it to Power BI
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
You can always install and configure the Oracle OleDB provider and use that instead of the default Oracle connector in PowerBI.
EG
let
Source = OleDb.DataSource("provider=OraOLEDB.Oracle.1;data source=//MyOracleServer/MySID;extended properties=""FetchSize=1000""", [Query="select * from ... )"])
. . .
RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.
Maybe look at the attuinity providers, they are available through the SQL Server feature pack. You can maybe pull a deal for Power BI as well....