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 don't know why but it works at my end. Assuming you pasted the whole code and replaced your existing code. Can you share pbix file using one drive/google drive to get your answer quickly? Remove any sensitive information before sharing it.

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.