Forum Discussion

Satish_Kumar's avatar
Satish_Kumar
Helper V
9 years ago

How to reduce the time for loading a data from SQL server.

Hi All,

 

I am here again with a most common and pathetic issue in Power BI,

In my case i almost find my self sleepy while i tried to load any table from my SQL server which is having rows in Lakhs.

the minimum time for one table is around 45mintues,

 

Please if anyone have some workaround regarding to this issue i will the most happiest person an very much thankfull.

 

for refernce here is the screenshot.....

 

 

 

Best Regards,

Satish Kumar

 

Need Help

11 Replies

  • Satish_Kumar's avatar
    Satish_Kumar
    Helper V
    9 years ago

    Hi All,

     

    Its almost 24 hours to my post, But till now have not receive any answer from our community.

     

    :mansad:

     

    Regards,

    Satish Kumar

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi Satish_Kumar,

       

          How many calculated columns you have created in your model to which you are trying to feed the data from sql. Also, when you are loading data from sql server than i advice you to use direct query mode instead of import while loading data in model.

       

      Direct query mode is really very good & is tightly integrated with power BI.

       

      Regards,

      Hemant

      • Satish_Kumar's avatar
        Satish_Kumar
        Helper V
        9 years ago

        Anonymous

         

        i have done with direct query mode.

        but takes as much time as i am importing through ODBC.

        if i do not have any calculated column and try import simply then the importing time will be minimus of 45 min. 

         

        Regards,

        Satish Kumar