Forum Discussion
Limit data on import
Hi there, What can I add to filter my data before it is imported into power bi. Currently I have a filter once the data is imported but my power bi has become very slow and laggy. See below for m...
my full query is quite long as I am doing more filtering and rearranging of columns after..However while the query does filter by 35 days, when I apply changes it still loads over 20 million records, while 35 days are only 4.5 million
Then it isn't filtering correctly, but without data or something to look at, I cannot say. It isn't a bug, it is the way the filter is being used. Unfortunately I cannot help further without some hard data to look at, like the native query generated by the filter.