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

There is no error, it just displays all of the query in red.

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