来自 Power Query 的 Power BI Desktop 增量表更新 [英] Power BI Desktop incremental table update from Power Query

问题描述

我从第三方 REST API 收集数据，该 API 有数千条记录，但每天都会更新更多记录，因此刷新我的数据源成为一项长期任务.所以我想知道是否有任何方法可以进行增量加载，并且只从 API 中抓取过去 30 天的数据并将其附加到 PowerBI Desktop 中的表中.

I'm gathering my data from a third-party REST API which has many thousands of records but updates each day with many more and so refreshing my data sources becomes a long task. So I was wondering if there was any way to do incremental loads and only scrape the last 30 days worth of data from the API and append that to a table in PowerBI Desktop.

我研究了附加查询功能，但这似乎只能连接 2 个查询并返回一个表，最终会遇到相同的问题，因为附加查询会随着时间的推移变得非常大.

I've looked into the append queries feature but this seems to only be able to join 2 queries and return a single table, which would eventually run into the same problems as the appending query will grow very large over time.

我真正想要的是一种在 PowerBI 中创建表格的方法，然后在每次查询刷新时更新该表格.有没有人看到这是否可能?

What I'm really looking for is a way to have a table in PowerBI which then gets updated on each query refresh. Has anyone seen if this is possible?

任何帮助都会很棒，谢谢.

Any help would be great, thank you.

推荐答案

我会将其分为两个过程:

I would break this into two processes:

1. 来自 REST API 的 Excel Power Query 提取的所有历史数据(例如，过滤上个月之前"，每月刷新)，交付到 Excel 表中.
2. Power BI 查询，通过 REST API 将存储的 Excel 历史数据附加到最近的数据中.

我会在 Excel 和 Power BI 中针对 REST API 的起始查询保持相同，因此可以轻松维护.然后，您可以将其引用到另一个应用所需的特定日期过滤器的查询中.

I would keep the starting Query against the REST API identical in both Excel and Power BI, so it can be easily maintained. Then you can Reference that into another Query that applies the specific date filters required.

这篇关于来自 Power Query 的 Power BI Desktop 增量表更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！