My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

Power Query 2016, data has been truncated due to the size limit.|Power Query|Excel Forum|My Online Training Hub

You are here: Home / Power Query 2016, data has been truncated due to the size limit.|Power Query|Excel Forum|My Online Training Hub

office scripts course

Avatar
sp_LogInOut Log In sp_Registration Register
sp_Search Search
Advanced Search
Search
Forum Scope



Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Search Search
sp_RankInfo
Lost password?
sp_PrintTopic sp_TopicIcon
Power Query 2016, data has been truncated due to the size limit.
Avatar
terry xue

Active Member
Members
Level 0
Forum Posts: 3
Member Since:
April 28, 2021
sp_UserOfflineSmall Offline
1
April 28, 2021 - 1:12 pm
sp_Permalink sp_Print

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.

Avatar
Mynda Treacy
Admin
Level 10
Forum Posts: 4614
Member Since:
July 16, 2010
sp_UserOfflineSmall Offline
2
April 28, 2021 - 8:29 pm
sp_Permalink sp_Print

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

sp_Feed
Go to top
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
jaryszek: 183
Newest Members:
Trevor Pindling
Stevan Kanjo
Erin Sheldon
Nikita Bhatia
Sheilah Taylor
Clare Webber
David Jenssen
Dominic Brosnahan
Young You
Jennifer Owens
Forum Stats:
Groups: 3
Forums: 24
Topics: 6524
Posts: 28554

 

Member Stats:
Guest Posters: 49
Members: 32808
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen