Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My api gives me the current date data every time for new date and I want to store the historical data and to add the new current date data.
But while refreshing the data gets overwritten and the past data gets lost.
Please share any solution.
WEB API:
Solved! Go to Solution.
Hi. The problem is that Power Bi is a tool for reading data. If you need to storage data from an api I suggest looking at azure services in order to build a process that takes data and storage it. You can use DataFactory or Azure Functions to read the api and then insert it in a lake gen2 or a database. That way you will save your own historical data that will be consumed by Power Bi later.
Regards,
Happy to help!
Hi. The problem is that Power Bi is a tool for reading data. If you need to storage data from an api I suggest looking at azure services in order to build a process that takes data and storage it. You can use DataFactory or Azure Functions to read the api and then insert it in a lake gen2 or a database. That way you will save your own historical data that will be consumed by Power Bi later.
Regards,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.