Forum Discussion

julhelp's avatar
julhelp
Helper I
4 years ago
Solved

REST api request in Power Query more than 1000 records

Hi,   i am facing the challange of requesting data from a REST service that limits the records by 1000. But i have data with more than 100.000 records. I am pretty new in power bi but my idea was t...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
4 years ago

Hi julhelp ,

As far as I know, 501 not implementet belongs to Server Error which means that 'Expect this when some requested operation isn't implemented'.

 

Whether try to use RelativePath in Web.Contents to modify it and check again, please refer:

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code 

 

In addition, you can also refer this simliar thread which introduces how to use custom function to paginate API record after getting the totalPage number in details:

How to get paginated data from API in Power BI 

 

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

julhelp's avatar
julhelp
Helper I
4 years ago

hi v-yingjl ,

i tried to insert a RelativePath in my case. I understand how it should work theoretically I manage to implement it but not in my code. There i cant insert all my things from Web.Contents.

 

can someone help me?