Solved: Dataflow is not showing all the data from a Web AP...

Anonymous · ‎01-15-2020

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 · ‎02-05-2020

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.

View solution in original post

Anonymous · ‎02-05-2020

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 · ‎01-15-2020

hi @Anonymous

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

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous · ‎01-19-2020

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!