Forum Discussion

rademar's avatar
rademar
Frequent Visitor
2 years ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Choose a balance between reducing the strain on the source system (pull only the data that you need) and your maintenance effort (DB management) .  Instead of a db you can also consider CSV or Parquet files for your storage.

lbendlin's avatar
lbendlin
Super User
2 years ago

1. You may need separate queries, especially if you are interested in acceptable performance.

2. Please refer to the API documentation for that

3. Yes, but you must eliminate/hide all dynamic parts of your URL.  Use RelativePath and Query attributes.  Power BI has no memory, your previous data will be lost.  If that data is immutable you will want to store that outside of Power BI (for example in a OneDrive).

4. See 3.   use the API and your own storage