Fabric pipeline between warehouses triggered on change

[SC_Developer]

Hi guys!

Here is my requirement:

I have a Power BI dataflow (from one Fabric Warehouse to another) and want to have it refreshed automatically when the source data is changed.

What I tried:

• Couldn't find an option to configure it within the dataflow.
• I put the dataflow into a PBI pipeline but couldn't find that kind of trigger neither.

Thanks for your help.

Cheers,

Martin

[KevinChant · Accepted solution]

Yes I do, depending on the location you could retain the data in the original warehouse and simply query it from the other one instead of duplicating the data.

[KevinChant]

Is there any particular reason why you need to duplicate the data between the Data Warehouses instead of creating a view to query the data in the other one?

[SC_Developer]

Hi Kevin, thanks for your reply. Do you mean SQL query?

I didn't think too much about whether I wanted to duplicate the data but I wanted to use the functionalities of power query.