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
vwiles84's avatar
vwiles84
Helper III
6 years ago

I started with a blank query, copied your coded and modified it to include the whole API call. 

parry2k's avatar
parry2k
Super User
6 years ago

vwiles84 so do you see the table or you are not even getting the table with all the columns before you make an api call, (before last step)

  • vwiles84's avatar
    vwiles84
    Helper III
    6 years ago

    I do not see a table or columns

  • 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.