将历史数据保存在本地数据库中以加快Power BI [英] Keep historical data in local database to speed up Power BI

问题描述

没有高级许可，是否可以模拟增量刷新以加快Power BI Desktop的速度？

Without a premium licensing, is it possible to simulate an incremental refresh to speed up Power BI Desktop?

说，我们将所有数据保留在特定日期之前一个本地Access数据库并仅在该日期之后连接到实时数据库以获取数据？
问题是如何将历史数据从一个或多个pbix文件导出到Access，我们该怎么做？

Say, we keep all the data before a certain date in a local Access database and connect to the "live" database only for data after that date? The question is how to export the historical data from one or several pbix file to Access, how can we do that?

推荐答案

尝试将其作为复合模型进行。使用导入将存档数据作为一个查询加载，而使用直接查询将最近的数据作为另一个查询加载。然后，您可以将其作为DAX计算表合并到表中，并用于报表。

Try doing it as a composite model. Load your archive data as one query using Import and your recent data as another query using Direct Query. Then you can union those to tables as a DAX calculated table and use that for your report.

如果您不使用Direct Query来获取最近的数据，或者您需要刷新模型，然后相信您可以在查询编辑器中取消选中包括在报表刷新中（在查询窗格中右键单击查询），除非您明确要求，否则它不会刷新该存档表。

If you aren't using Direct Query for recent data or you need to be refreshing your model, then I believe you can uncheck "Include in report refresh" in the query editor (right-click on the query in the Queries pane) and it won't refresh that archive table unless you specifically ask it to.

这篇关于将历史数据保存在本地数据库中以加快Power BI的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！