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 am having performance issue with one of my new dashboard with
Data source in AWS - Oracle.
The connection type is Oracle DB
Its a very small table with less than 2000 records taking over 10 minutes to get the data.
Is there anything that i can do to get this going faster.
Does power bi have any other connection type to connect to AWS Oracle data source that performs better than the default Oracle DB connector?
Hi @Anonymous,
Performance issue is a complicated question. I would suggest you upgrade the Desktop and the Gateway. And try again later. Maybe adding more bandwidth of the AWS would help.
Best Regards,
Dale
I tried running the same query using other oracle client tools like SQL Developer. the response tiem is less than 4 seconds to get the full dataset. I also tried publishing the dashboard and refresh online, even that took around 16 minutes.
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |