Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I need some information to built a report through an API call.
Calling the API works fine, but I've an additional challenge...
- The value returned by the API is either "unknown" or a date. Once the date is known, it no longer changes ==> So I need only one API call. It is useless to call the API again during later refresh.
- The API doesn't keep history over 2 months. The API reply is then back "unknown" ==> I need to record the date previously provided by the API to keep an history longer than 2 months
Any suggestions about how to do that? I've started to create a new table, but I can't figure out how to update this table with new API replies to keep them over time.
Any help appreciated of course!
Solved! Go to Solution.
Hi @turbofred69 ,
You can try to use data flow and incremental refresh to save historical data.
https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @turbofred69 ,
You can try to use data flow and incremental refresh to save historical data.
https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
User | Count |
---|---|
5 | |
5 | |
4 | |
4 | |
3 |