Forum Discussion
Solved
Full Data Table Loading instead of just the Query defined in Power Query
Due to confidentiality within my company I cannot share my dataset, but I will do my best to share some details. I have a table that gets approximately 2.5 million rowas added to it each day as an a...
lowdman87 , if the query folding is not proper then power query may load full data
https://docs.microsoft.com/en-us/power-query/power-query-folding
so check for that.
Also if possible use a query in advance option of connection or create a view on database side and use
Hi there!
What you could do to prevent from Power BI to read the whole table is using a native query so it applies the filter before it reaches Power BI. If your connection supports native queries then you should try this.
If you are not sure what these are, here is the Microsoft documentation.
https://docs.microsoft.com/en-us/power-query/native-database-query
If you have any question please let me know!