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
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,