Connecting to Oracle DB table Slow

Chris74 · ‎10-14-2015

I want to connect Power BI to an Oracle DB table containing millions of records. That is going really slow. Is there a way to speed up this process?

mike_honey · ‎10-28-2015

If your requirements include any Filters, I would apply them as the first Step (after Navigation). They should be passed through to the generated SQL statement and executed against Oracle, to reduce the volume of data extracted.

If you cant do that, try adding a Keep Rows Step e.g. Keep the Top 100 rows. Again this should get passed through to Oracle to speed it up. Once you have finished designing your Query you can delete that step.