Forum Discussion
Solved
API connection, time series analysis issue
Hi Everyone, I've never userd API as a data source so far (always had a direct access to db). But for this project I got API documentation and I don't have a clue what to do... This is a smal...
Because I need up to date data + historical data, I guess I need to make a database and to schedule api calls each day so the dataset is up to date.
This is my line of thinking:
1. Setup Azure SQL database
2. Scrypt makes api calls each day and fills the database with new data every day.
3. PowerBI connects to Azure SQL database
4. Scheduled refresh in PBI Service.
Did I miss something? Does this setup make any sence? Any alternative ideas?
lbendlin
Super User
Super UserDoes the data behind the API change after the fact? For example if you pull yesterday's data, will that then be it or do you have to repull it after some time to catch the changes?