topic Re: Relationship between two query for Filter in Report Server

Relationship between two query for Filter

BishwaR — Thu, 19 May 2022 20:20:11 GMT

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

Re: Relationship between two query for Filter

FarhanAhmed — Fri, 20 May 2022 10:47:05 GMT

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

Re: Relationship between two query for Filter

BishwaR — Fri, 20 May 2022 19:36:25 GMT

Thank you