Forum Discussion
How to reduce the time for loading a data from SQL server.
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
Anonymous
no buddy said that i am bounded with certain condition.
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