Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |