Forum Discussion

imranamikhan's avatar
imranamikhan
Helper V
3 years ago
Solved

Return all rows from JSON Query

Hi everyone,   I am currently using the below to API call to a Dataverse table. Unfortunately, this results in only the first 500 rows being returned.     let Source = Web.Contents(https://...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi imranamikhan ,

     

    According to your statement, I think your requirement is to overcome API call row limit.

    Please see this video for a good approach to do this.

    Power BI - Tales From The Front - REST APIs - YouTube

     

    Best Regards,

    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

imranamikhan's avatar
imranamikhan
Helper V
3 years ago

Hi JoeBarry - the table in question is the Audits entity, which is not accesible via the Dataverse connector. It can be accessed however via a Web API.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi imranamikhan ,

 

According to your statement, I think your requirement is to overcome API call row limit.

Please see this video for a good approach to do this.

Power BI - Tales From The Front - REST APIs - YouTube

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.