Forum Discussion
Data refresh question.
In short, if you are using "Import" the answer is no. It is always a case that Power BI clears and fetches the data again. This means you need to make sure your import statements are contrained to only get the data you require. For example exclude rows and columns that you don't need.
As an alternate, if your data source is truely massive and you don't need every single function, you could consider a Direct Query. This will reduce how much you download in a single hit, but will require a more sustained performance hit on your data bases.
Thank you, the data set is quite wide and about 300 million records in total. We'll look at what we can do to limit the data that comes in and have a go at setting up a direct query with parameters. Thanks for your response!