Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Good afternoon,
*I searched for similiar posts but not much seems out there regarding this error, except that it could be something with underlying data.
*I run 8GB Ram, i7 processor, using power bi desktop.
Any thoughts on what the below means? I was importing several Excel files from a folder. I'm thinking it could be a memory limit or data limit. The underlying data seems fine.
Thank you,
Jaes
Solved! Go to Solution.
Hi @Jkaelin,
I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.
Regards,
Xiaoxin Sheng
Hi @Jkaelin,
How many characters 'data id range' column stored? How many columns? Can you please provide more detail informations?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Anonymous,
I don't have a column labeled, "Data ID range". I believe this is a microsoft error. The table has 80 columns. Sorry if I didn't initially provide enough information.
I guess I'm asking if their is any source that explains errors so I know best where to troubleshoot?
Thank you,
Hi @Jkaelin,
I think this should related to query editor transform operations, have you enabled any advance transform operations in query editor?(combine, merge, append, refer other query, custom functions)
BTW, I test to get data for excel table with hundreds of columns but can't reproduce your issue.
Regards,
Xiaoxin Sheng
@Anonymous
Thank you for your help. After an extended period of testing, it appears some values have an extensive character length. Although not resolved, I was able to pin-point the columns. This thread helped me narrow down the troubleshooting. Thank you.
Hi @Jkaelin ,
I'm with the same problem as you were.
Could you please tell me what did you do to find the value with an extensive character length?
Thanks!
I had to count how many characters were in the some columns. I used Power Query to trim the character lenght in some of the columns that had long names. That may help!
User | Count |
---|---|
60 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
40 | |
39 |