Skip to main content
Microsoft Idea

    Power BI

    Completed

    Faster oracle database connection. The existing one is slow compared to the SQL Server one.

    Vote (47) Share
    Ken Lewen's profile image

    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)
    Ken Lewen's profile image Profile Picture

    Power BI User on 05 Jul 2020 23:16:06

    RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.

    Any updates on this

    Ken Lewen's profile image Profile Picture

    AlexBrisebois on 05 Jul 2020 23:10:50

    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...

    Ken Lewen's profile image Profile Picture

    pwvtg on 05 Jul 2020 23:10:39

    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.

    Ken Lewen's profile image Profile Picture

    Azhar Sayyad on 05 Jul 2020 23:10:34

    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?

    Ken Lewen's profile image Profile Picture

    Matthew Moore on 05 Jul 2020 23:08:20

    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?

    Ken Lewen's profile image Profile Picture

    William Tamaro on 05 Jul 2020 23:07:22

    RE: Faster oracle database connection. The existing one is slow compared to the SQL Server one.

    Hello, any update? I have the same issue... ='(

    Ken Lewen's profile image Profile Picture

    kapil Dev on 05 Jul 2020 23:03:16

    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...

    Ken Lewen's profile image Profile Picture

    Shiva on 05 Jul 2020 23:03:15

    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

    Ken Lewen's profile image Profile Picture

    David Browne on 05 Jul 2020 22:38:50

    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 ... )"])
    . . .

    Ken Lewen's profile image Profile Picture

    Mattias Lind on 05 Jul 2020 22:31:46

    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....