PowerBI - 并行自动更新问题 [英] PowerBI - Problem with parallel auto-update

问题描述

我的数据集由十几个表组成，每个表都有自己的 clickhouse 查询.有些请求比较繁重，但是每个请求都是单独执行的，没有超过使用资源的限制.

My dataset consists of a dozen tables, each with its own clickhouse query. Some of the requests are quite heavy, but each of them is executed separately, without exceeding the limit on the resources used.

但是当仪表板在预定时间更新时，所有这些请求都开始同时执行，这会导致源的混乱和由此产生的错误:DB::Exception: Memory超出限制(总数).

But when the dashboard is updated at the scheduled time, all these requests start to be executed simultaneously, which causes confusion of the source and the resulting error: DB::Exception: Memory limit (total) exceeded.

有人知道如何要求 PowerBI 以预定更新顺序(不是同时)执行请求?

Anyone have any ideas how to ask PowerBI to execute requests sequentially (not simultaneously) with a scheduled update?

也许可以添加带有sleep"的 M 代码；职能?或者像这样:

Maybe it's possible to add M-code with "sleep" functions? Or something like this:

if (
    nothing updating now,
    let Source = Odbc.Query(...) in Source
)

推荐答案

在 Power BI 中没有直接的方法来执行此操作.桌面确实有一个设置来启用/禁用表的并行加载，但是一旦您部署到服务，它就不起作用.唯一的选择是使用数据流.然后，您可以设置一个计划来填充它们，或者设置一个 Power Automate/逻辑应用/数据工厂来点击 API 以按某种顺序调用它们.

There is no direct way to do this in Power BI. The desktop does have a setting to enable/disable parallel loading of tables, but it doesn't work once you deploy to the service. The only option would be to use dataflows. You can then set a schedule to populate them, or set up a Power Automate/Logic app/Data Factory to hit the API to call them in some order.

这篇关于PowerBI - 并行自动更新问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！