Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Data Import Performance is very slow in Power BI Desktop

Hi,  I have a custom SQL Query in Oracle that i am importing in Power BI Desktop. It has 8.9 Million Rows. It took roughly 18mins to extract in Tableau but took roughly 2.5hrs in Power BI. Even fo...
Need Help
Show and Tell
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous

Before you load the data from Oracle into power bi desktop, You'd better shape the data set in Edit Queries,

for example:

You could remove the useless columns, filter data, etc.  

These actions could reduce the size of the dataset and improve the performance of import data

You could also use DirectQuery instead of Import.

 

Best Regards,

Lin

 

cuiping's avatar
cuiping
Frequent Visitor
7 years ago

I always do this Edit steps, but not helpful much. I use Excel to retrieve same data it tooks much shorter time as compared to Power BI, not to mentione for Power BI, there is additional time required for Save&Apply step also.

  • michaelmof's avatar
    michaelmof
    Regular Visitor
    7 years ago

    We have the same problem and I cannot find anywhere that PowerBI has addressed this problem. DirectQuery is not an option for the users that will be creating some reports as their Oracle SQL skills are not that great. Excel connects and brings the data in quickly. do the PowerBI and Office XLS teams actually communicate and work together to solve this issue?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi, 

       

      I've the same problem, I have almost 3M rows and it's so slow. 

       

      If you have find a solution, do not hesitate to share, i'm really curious ! 

       

      Have a nice day,