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
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