Forum Discussion

moltra's avatar
moltra
Helper IV
5 years ago
Solved

storing data from a web API

I am going to be pulling data from a web API on a weekly basis.  The API returns 7 days of data at a time.  I will be refreshing this data Either daily or Weekly.     I want to save the data retrie...
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    moltra maybe use ADF (Azure Data Factory) or Power Automate, make an API call, store data on blob storage or insert in SQL Server and then use Power BI to read from the stored data.

     

    Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

parry2k's avatar
parry2k
Super User
5 years ago

moltra maybe use ADF (Azure Data Factory) or Power Automate, make an API call, store data on blob storage or insert in SQL Server and then use Power BI to read from the stored data.

 

Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡