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.
There is no way to "prefilter" a flat file as there would be no way to achieve such a thing. The only reason you can do this with a database is that you make a request to the data base server, which has a database engine running on it, which is able to do the filtering on your behalf and send you the result.
With a flat file, there is no engine running on the hosting server that could produce a stripped down version of the file to send you as part of a request.
There is no way to "prefilter" a flat file as there would be no way to achieve such a thing. The only reason you can do this with a database is that you make a request to the data base server, which has a database engine running on it, which is able to do the filtering on your behalf and send you the result.
With a flat file, there is no engine running on the hosting server that could produce a stripped down version of the file to send you as part of a request.
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.