cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nadi_123
Frequent Visitor

Applying query changes is very slow - Oracle datasource

Hello everyone.

 

Please help!!

 

I am a newbie to Power BI and hoping to get some help here. I tried a couple of options for my problem as read in community forums but can't get it resolved.

 

I am trying to connect to an Oracle database through the Power BI desktop (version 2.74.5619.862 64-bit) and trying to load 1million records, which is valid and can't reduce the data set. I haven't progressed any far other than just loading and transforming the data at this stage( one date transformation step).

 

The issue is when I apply one small step via query editor it is taking hours (~5 hours) to apply the change in the query editor, is this a valid limitation and can't be resolved even with a premium account or is there any adjustments to the settings that can be done to overcome or reduce this time. I am really concerned about how the performance will be going forwards in using the Query editor with this dataset.

 

I have used Tableau to check the network speed limitation criteria and it is loading the data in less than minutes, so I don't think it is a limitation of the network.

 

 

I tried a couple of options like

 

1. Unchecking the preview download option in Data load

2. Changing privacy setting to Organizational

3. The auto time intelligence function is turned off.

 

Any help is very much appreciated.

 

Thanks.

 

 

 

 

4 REPLIES 4
Anonymous
Not applicable

@Nadi_123 - One troubleshooting step is to check the memory and CPU usage on your machine. Please let us know whether one of those is an issue.

@Anonymous  - I tried the troubleshooting option, does the below looks like a huge usage? I have noticed the CPU usage varies up to 60% while I monitor the progress. I appreciate your time, thanks.

CPU_performance.png

 

Anonymous
Not applicable

@Nadi_123  - No, it appears that the RAM and CPU are fine. Can you do a trace to pick up what queries are running on the Oracle side and their performance? I'm not sure whether the date transformation will be sent to Oracle as part of the SQL query - "Query Folding".

 

@AnonymousThanks for responding. I am using a view to connect with Oracle data so will that matter from a performance perspective, I need to investigate if so. I will research a bit on query folding and see if that transformation step is slowing down the performance.



Thanks for the suggestions.

 

 

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors