Forum Discussion
REST api request in Power Query more than 1000 records
Please see this video for a good approach to do this.
Power BI - Tales From The Front - REST APIs - YouTube
Pat
Hard to tell without seeing the M code for TabelleName, Username, and Token (I assume those are other queries), but I would hard-code those in (instead of referencing them) to confirm it is working like that. You can then reference them one at a time to focus on the one that needs to use the approach described in that link.
Pat
that helped 🙂
the problem was the query where i am getting the total number of records.
But still i have an error:
DataSource.Error: Web.Contents failed to get contents from '.../api/v1/tables/S012&limit=1000&offset=0' (501): Not Implemented
Details:
DataSourceKind=Web
DataSourcePath=.../api/v1/tables/S012&limit=1000&offset=0
Url=.../api/v1/tables/S012&limit=1000&offset=0
what means "not implementet"?
this is my code:
I think it is a problem with the limit and the offset. Because if i am not using them, everythink is fine. But then i just get 1000 records.
I hope you or anyone else can help me here...
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.
