Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |