Solved: Import data using API into Power BI

Anonymous · ‎09-18-2018

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

Anonymous · ‎09-19-2018

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

View solution in original post

v-yuta-msft · ‎09-19-2018

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 · ‎09-19-2018

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