Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
SC_Developer
Frequent Visitor

Fabric pipeline between warehouses triggered on change

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

1 ACCEPTED SOLUTION
KevinChant
Resolver I
Resolver I

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.

View solution in original post

3 REPLIES 3
KevinChant
Resolver I
Resolver I

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
Resolver I
Resolver I

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?

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

SC_Developer_1-1712212948467.png

 

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

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors