Forum Discussion

julhelp's avatar
julhelp
Icon for Helper I rankHelper 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
freginier's avatar
freginier
Icon for Solution Sage rankSolution Sage
4 years ago

Do you have the same result if you send the request from postman or a browser ? 

julhelp's avatar
julhelp
Icon for Helper I rankHelper I
4 years ago

I can get the total of the records as number but if i request the data i just get 1000.  

  • freginier's avatar
    freginier
    Icon for Solution Sage rankSolution Sage
    4 years ago

    Sorry but It's Power BI API or other application API ? 

    • julhelp's avatar
      julhelp
      Icon for Helper I rankHelper I
      4 years ago

      Excel Power Query but it´s similar to Power BI