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?
Solved! Go to Solution.
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,
An accepted solution is always sticked immediately after the original post:
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.
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?
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 .