Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to Solution.
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!
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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |