cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ChenChristyYu Regular Visitor
Regular Visitor

Limit of 1000 value reached

Hi Experts,

 

I am new to PowerBI.

I am pulling data from servers in my corp, and I notice this error on my edit query page. Does this error message mean that I can only load and show a limited amount of data on my dashboard? I do need all the data pull in, what should I do?

 

Thanks!!!!

Tdata load bug.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
rocky09 Senior Member
Senior Member

Re: Limit of 1000 value reached

@ChenChristyYuNo, it is just limitation. But, you will get all data into your Data Model. Cheers.

8 REPLIES 8
rocky09 Senior Member
Senior Member

Re: Limit of 1000 value reached

@ChenChristyYuNo, it is just limitation. But, you will get all data into your Data Model. Cheers.

Highlighted
Nobuko_ao Frequent Visitor
Frequent Visitor

Re: Limit of 1000 value reached

Hi, experts.

 

I have same question and clicking <view solution in original post> but nothing had happen.

Please advise where can I find the solution.

 

Many thanks in advance,

 

best

 

Nobuko_ao

 

rocky09 Senior Member
Senior Member

Re: Limit of 1000 value reached

@Nobuko_ao

Read the 2nd post.

Nobuko_ao Frequent Visitor
Frequent Visitor

Re: Limit of 1000 value reached

Dear rocky09,

 

What do you mean by 

>Read the 2nd post.

 

Where is 2nd post?

Sorry but I cannot find the solution of  this issue.

 

Thanks

 

Nobuo_ao

 

 

RMDNA Senior Member
Senior Member

Re: Limit of 1000 value reached

An accepted solution is always sticked immediately after the original post:

 

a.PNG

 

To answer the question again: no, the 1000 value limit in the Query Editor dropdown menus is only a limitation on how many values are loaded into the dropdown. It is not a limit on actual data importing.

Nobuko_ao Frequent Visitor
Frequent Visitor

Re: Limit of 1000 value reached

Dear RMDNA,

 

Thanks, so your answer measn that "limit of 1000 is just  "how many values are loaded into the dropdown",

and my data (3,200 raw) is succesfully imported. 

Am I right?

 

best

 

Nobuko_ao

RMDNA Senior Member
Senior Member

Re: Limit of 1000 value reached

@Nobuko_ao,

 

Correct.

VB Frequent Visitor
Frequent Visitor

Re: Limit of 1000 value reached

Hi ,

 

Continuing this thread , i am query editor and i need to remove "n/a" which are somewhere in row no 1500 but query editor displays only 1000 rows..would like to know if there is any other option to remove such blanks feilds as it gives Data fomat error during saving .

 

And how do we resolve errors reported in query editor.

 

Thanks for your time .

 

Cheer's

VB