Forum Discussion
Syndicate_Admin
Administrator
AdministratorOnce 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% Err...
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.
V-lianl-msft
Community Support
Community SupportHi 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.