Import data using API into Power BI

[Anonymous]

i need to pull data from web using api, i am able to get data. but there is a limit on number of rows that i can import from the source.  I  heard that by adding jason parts to that url , we can get all rows. Can anyone help with this

[v-yuta-msft]

Hi reddy_powerbi,

How many rows do you want to import from web?Are use using restful api or other function to achieve these data? Can you clarify more details about your requirement?

Regards,

Jimmy Tao

[Anonymous · Accepted solution]

i'm trying to import more than 2000 rows from workfront api, but  workfront has limit of max 2000 rows that we can export. i choose jason to open the file in powe bi connection. Im not sure how we can achieve this. but  i see couple of posts about pagination by adding some scripts to the api url, so that we can pull  the data from all the pages.

i was looking below post as example,

http://sqlcodespace.blogspot.com/2017/09/power-bipower-query-api-response.html