Forum Discussion

vwiles84's avatar
vwiles84
Helper III
6 years ago

Rest API - 90 Day restriction

I have access and connected to a rest API to pull in some sales data. The api is restricted to 90 days worth of data.  My question is, how do I configure Power BI to pull in current data while archiv...
Tips and Tricks
parry2k's avatar
parry2k
Super User
6 years ago

vwiles84 seems like  code is not copied correctly, you should be seeing this

 

vwiles84's avatar
vwiles84
Helper III
6 years ago

When I copy the code in the query, it converts it to this

  • vwiles84's avatar
    vwiles84
    Helper III
    6 years ago

    OK i got it to work by using the advanced editor.

  • vwiles84's avatar
    vwiles84
    Helper III
    6 years ago

    But it is erroring out and not brining in the sales data. it's just showing the 2 date.  Trying to view the error locked up my query editor. So I'm not sure this is going to work. 

     

    I will try to connect the 4 calls with the date range in 90 day intervals.  I can make multiple calls so I just have to find the best way to do that. 

    Thanks for your help.