Forum Discussion
Once con problem
Hello, I have an Odata connection and I am having certain problems with some columns and is that even if they have data, when generating the profiles based on the complete data set I get Valid 0% Error 0% and Empty 100%, also when I exceed 1000 rows the data disappear and I only get "null". Do you have an idea of what the problem may be and a possible solution? Thank you very much in advance
Hi Syndicate_Admin ,
You can get only 1000 rows in one JSON file (default limitation). Please try to use List.Generate() in power query .
You can refer to this thread:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Syndicate_Admin ,
You can get only 1000 rows in one JSON file (default limitation). Please try to use List.Generate() in power query .
You can refer to this thread:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.