Forum

Power Query 2016, d...
 
Notifications
Clear all

Power Query 2016, data has been truncated due to the size limit.

2 Posts
2 Users
0 Reactions
741 Views
(@terry1)
Posts: 3
Active Member
Topic starter
 

when loading the data, the above error was shown.  can you please advise how to fix it? Trying to do one of your Power Query exercise on Youtube

Only 250 rows can be displayed in the Query Editor. Excel version using is Microsoft Office Pro Plus 2016.

 
Posted : 28/04/2021 11:12 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Terry,

Welcome to our forum!

It sounds like something went wrong because none of my example files should return that error. Can you please share your file?

Mynda

 
Posted : 29/04/2021 6:29 am
Share: