Hi everyone,
I need your help understanding triggering dataflows. Let's take a simple example:
Workspace 1:
DF Data:
- Table "Data" with one column "version" and data like, 1, 2, 3,...
Workspace 2:
DF 1:
- Table "Trigger" with e.g. Timestamp = LocalDatetime.Now()
=> This table is my trigger. I want to refresh this DF scheduled and it should trigger a refresh of DF2.
DF 2:
- Linked entity of Trigger (DF1) -> This table is triggered by refreshing DF1.
- Linked entity of Data (DF Data)
- Computed Entity of table Data with e.g. [version] + 1 (Data_Comp)
By refreshing DF1 the refresh of DF2 will start automatically because of the linked table "Trigger". But it will only refresh the linked Entity. My computed table Data_Comp stays unrefreshed until I refresh manually or sheduled the DF2.
Is there a way to refresh the whole DF2 by triggering only one table from DF1?
I found a workaround by loading the table Data in DF1 as linked entity (Data_LE). Additionally I need a loaded computed table of Data_LE in DF1. And then I can relate to this computed table from DF1 in DF2.
In my opinion this workaround creates a lot of redundant data. This might work for small Dataflows. But in our Dataflows with a lot of tables it slows everything down and the whole process gets unhandleable.
I also found a way with Power automate. But I would like to solve this in PBI. I am missing an option like "refresh only triggered tables" vs. "refresh the whole dataflow by triggered tables"...
Kind regards,
Tobsen
