Forum Discussion
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 Lakh...
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
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