Excel Forum

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

terry xue

Posts: 3

April 28, 2021 - 1:12 pm

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.

Mynda Treacy

Posts: 4443

April 28, 2021 - 8:29 pm

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

Forum Timezone:
Australia/Brisbane

Most Users Ever Online: 245

Currently Online: Richard Benson-King

Guest(s) 9

Currently Browsing this Page:
1 Guest(s)

Devices in use: Desktop (6), Phone (4)

Forum Stats:

Groups: 3

Forums: 24

Topics: 6205

Posts: 27210

Member Stats:

Guest Posters: 49

Members: 31878

Moderators: 3

Admins: 4