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