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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mohida
New Member

How to implement Change Data Capture

Hi Team,

I have several big query tables, from which I need to bring the data to my fabric warehouse. I have created a control table in my warehouse where i maintain the last update dates pertaining to a table. I use a dataflow to bring data from bigquery table to warehouse table. Now i want to include a filter here which filters the data for - last_update-date >= (value from control table). 

How should we implement this in dataflow ? Or how should one implement this using data pipelines ? Please suggest. 

 

Also , Currently i do not see a way to pass a parameter from datapipeline to dataflow. Please let me know the correct approach for the above scenario ? 

 

Regards

Mohida

1 ACCEPTED SOLUTION
miguel
Community Admin
Community Admin

Hi!

Can you create a query which yields the value for (value from control table)? if yes, you can pass that as a filter of the query that you want to use it with as part of a "Filter rows" or Table.SelectRows function

 

There is currently no way to pass a parameter from a pipeline to a Dataflow. You can vote for this idea to be implemented using the link below:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f761603-a400-ee11-a81c-6045bdb98602 

View solution in original post

2 REPLIES 2
miguel
Community Admin
Community Admin

Hi!

Can you create a query which yields the value for (value from control table)? if yes, you can pass that as a filter of the query that you want to use it with as part of a "Filter rows" or Table.SelectRows function

 

There is currently no way to pass a parameter from a pipeline to a Dataflow. You can vote for this idea to be implemented using the link below:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=2f761603-a400-ee11-a81c-6045bdb98602 

Anonymous
Not applicable

Hi @Mohida 
We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
Thanks

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric update to learn about new features.

Top Solution Authors
Top Kudoed Authors