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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
BishwaR
Helper V
Helper V

Relationship between two query for Filter

I have two queries via ODBC connection from Oracle server. I not have have the physical tables for both  queries. I am using SQL to bring them to Report Builder. Now I want to use table A for the paramerter to filter the values in Table B.

 

I created the Selected Values in the parameter and it works perfectly but it does not filter table B because there is no relationship between them on the Primary columns. How can I create the relationship so that one table can filter other

 

Thank you

1 ACCEPTED SOLUTION
FarhanAhmed
Community Champion
Community Champion

kindly check below artcile to set dependent parameters

 

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

Use cascading parameters in paginated reports - Power BI | Microsoft Docs







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
FarhanAhmed
Community Champion
Community Champion

kindly check below artcile to set dependent parameters

 

Report parameters in Power BI Report Builder - Power BI | Microsoft Docs

Use cascading parameters in paginated reports - Power BI | Microsoft Docs







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




Thank you

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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