power query filtering data

[mazharacca]

I am currently using power query excel 2016, when applying power query the following message displaced "the data in the preview has been truncated, reducing the number of columns or filtering may load more data."

 

[Alex Blakenburg]

Unless you are having issues with your final output, the number of rows you are seeing in the preview should provide enough data to work out what transformation steps you need to perform.

It is likely that you have exceeded the Limit of "Number of cells in a Query Editor data preview 3,000 cells"

Power Query specifications and limits in Excel - Microsoft Support

support.microsoft.com