Forum Discussion
Syndicate_Admin
Administrator
Administratorundefined
Good! I've gotten stuck with an idea of implementing a data flow in a Power BI report, to see if you could help me, please. The problem is as follows: I have a query against SQL Server that turns ...
Hi Syndicate_Admin ,
Actually to my knowledge, Power BI is a "read only" system so it doesn't have the ability to store data beyond a refresh. If possible, you should stage a copy of each day’s data in a relational database (ie build that data warehouse) or even as text files in a folder (Power Automate may be useful to do this)
For more information, you could refer to this blog——Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using Incremental Refresh
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.