Forum Discussion
How to reduce the time for loading a data from SQL server.
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
how many lines you are importing in your model collectively i.e aggregation of total no. of line in each table you are tryng to import in your model for analysis from sql server.???
I am working with sql server too & have imported more than 10 million lines of data in 6 tables collectively in my model. total time it took was arround 15-20 minutes.
I suspect you have lots of unique values in every column,something simillar to primary key. If this is the case than reducing time for import will be very difficult as power BI internally woks on in memory columnstore technology. Lots of unique vale means lots of compression & hence increased time for data load.
Hope this helps.
Regards
Anonymous
See this cases will come when i will import the data.
let suppose if i am able to import them any how but how should i applied the filter on the table if we do not have any permission for doing that.
So if there is any other workaround please do revert.
And i am importing data about 72lakhs of rows.
Regards,
Satish
who said data cannot be filtered ???
You can filter data in edit query mode after importing data & also use dax funtion "filter" to filter out things as per your requirement.
Regards