cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ceenuu Regular Visitor
Regular Visitor

Oracle data source in Amazon AWS slow performance

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?

 

 

 

2 REPLIES 2
v-jiascu-msft Super Contributor
Super Contributor

Re: Oracle data source in Amazon AWS slow performance

Hi @Ceenuu,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ceenuu Regular Visitor
Regular Visitor

Re: Oracle data source in Amazon AWS slow performance

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.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 357 members 3,501 guests
Please welcome our newest community members: