如何在Powerbi中保存旧数据?

本文介绍了如何在Powerbi中保存旧数据?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在使用Web API将数据导入Powerbi.每次刷新后，旧数据将被Web API的新数据替换，所以我的问题是如何将旧数据存储在Power Bi中?

I'm using web api to import data into powerbi. After every refresh, old data is replaced by new data of web api so my question is how can I store that old data in power bi ?

推荐答案

除非您具有支持增量刷新的查询源，否则Power BI将不会存储数据.

Power BI will not store data, unless you have a query source that will support incremental refresh.

docs.microsoft /en-us/power-bi/admin/service-premium-incremental-refresh

最好使用Azure Function，Azure Logic Apps或Power Automate之类的工具来获取数据并将其另存为文件，然后从该文件夹导入数据.另一种选择是将数据移动到数据库表中以保留历史记录.

It would be best to use a tool like Azure Function, Azure Logic Apps or Power Automate to get the data and save it as file to a folder then import the data from the folder. Other option would be to move the data to a database table to preserve the history.