Forum Discussion
Drill-through Not Working Between Pages Using Different Data Sources in Power BI
Close to the solution, Make only one relationship active at a time.
In your model view, keep the relationship from Dim_table → TableB active.
Keep the Dim_table → TableA relationship inactive (unless you need it for measures).
Check below :
1.Visuals on the main page are from Dim_table
2.Visuals on the target page are from TableB and Dim_table.
3.This ensures filter propagation flows cleanly during drill-through from Dim_table to TableB.
this works, Ensure your drill-through filter field is the same field used in the relationship (i.e., KeyColumn from Dim_table).
Hi rajendraongole1 , thanks for the suggestion. Here’s what I’ve implemented so far:
- Created a Dim_table using a UNION of TableA and TableB.
- Added a keycolumn using RowNumber across TableA, TableB, and Dim_table.
- Established many-to-one relationships from:
- Dim_table → TableA
- Dim_table → TableB
- Used common columns from Dim_table in the visuals on both pages.
- Added a drill-through filter sourced from Dim_table.
- Structured the report pages as follows:
- Main page: All columns are from Dim_table since they’re required for drill-through.
- Target page: Contains columns from both Dim_table and TableB.
However, the drill-through isn’t functioning as expected:
- It redirects to the target page but includes more records than it should.
Close to the solution, Make only one relationship active at a time.
In your model view, keep the relationship from Dim_table → TableB active.
Keep the Dim_table → TableA relationship inactive (unless you need it for measures).
Check below :
1.Visuals on the main page are from Dim_table
2.Visuals on the target page are from TableB and Dim_table.
3.This ensures filter propagation flows cleanly during drill-through from Dim_table to TableB.
this works, Ensure your drill-through filter field is the same field used in the relationship (i.e., KeyColumn from Dim_table).