Dataflow is not showing all the data from a Web API

[Anonymous]

Hi People!

I have created a dataflow that takes the data from a Web API but it doesn't show all the data, I did a test, and with Postman I received all the data from the API.
Maybe I'm doing something wrong but I don't know what.

Thank you so much for your attention! 🙂

[Anonymous · Accepted solution]

Hi!

Finally the issue is solved, the problem came from the authentication from the API, the company that provide us the database and API had a bug in the login.

[v-lili6-msft]

hi  @Anonymous 

In Edit Queries of power bi, it only shows 1000 rows preview data in it for you to do transform.

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft,
First of all, thank you so much for reply to my problem.
It only shows 1000 rows preview data in it for you to do transform but later shows all the data (When you are not in the preview)?
Another thing is that the records in the preview start with ID number 8 and in the API with ID number 1, how is that possible because in theory is taking the information from the same place.

Thank you so much!