I connected Power BI with my M-Files via the Rest API. Everything works as expected but the query only gets 200 rows.
I tried the limit=500 parameter and that increased my results from 200 to 300. I also tried the currentPageNumber and maximumRows parameters but these doesn't seem to work.
Is there a way to increase the number of resulting rows for the View api call?
Here is my rest api call in Power BI:
"">server_ip/.../objects"
Here are Power Query to get all documents in vault. You need to add ?limit=0 to query to get unlimited results.
Unfortunately this not seems to be working on view path ie. /views/v134/objects?limit=0, doesn't work. But directly in search (objects) its working.
let
Source = Json.Document(Web.Contents("localhost/.../0?limit=0", [Headers=[#"X-Vault"="{VAULT-GUID-HERE}", #"X-Username"="Username", #"X-Password"="Password", #"Content-Type"="application/json"]])),
Here are simple example with sample vault, to get documents and class structure.
https://jaloit.blob.core.windows.net/public/Example Vault.pbix
For rest api, i recommend to check Postman first and check https://github.com/M-Files/MFilesSamplesAndLibraries/tree/master/Libraries/Postman/ this libraries. 
Here are Power Query to get all documents in vault. You need to add ?limit=0 to query to get unlimited results.
Unfortunately this not seems to be working on view path ie. /views/v134/objects?limit=0, doesn't work. But directly in search (objects) its working.
let
Source = Json.Document(Web.Contents("localhost/.../0?limit=0", [Headers=[#"X-Vault"="{VAULT-GUID-HERE}", #"X-Username"="Username", #"X-Password"="Password", #"Content-Type"="application/json"]])),
Here are simple example with sample vault, to get documents and class structure.
https://jaloit.blob.core.windows.net/public/Example Vault.pbix
For rest api, i recommend to check Postman first and check https://github.com/M-Files/MFilesSamplesAndLibraries/tree/master/Libraries/Postman/ this libraries.
