Once con problem

[Syndicate_Admin]

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

[V-lianl-msft · Accepted solution]

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:

https://community.powerbi.com/t5/Power-Query/Help-with-recursive-web-power-query-oDATA-SuccessFactor... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.