Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Drill-through Not Working Between Pages Using Different Data Sources in Power BI

I’m trying to implement a drill-through from a main page to a subpage in Power BI. Each page is based on a different underlying data source, though both tables have the same column structure. However...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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).

v-echaithra's avatar
v-echaithra
Community Support
1 year ago

Hi Anonymous ,

Thank you for sharing your update and confirming that the issue has been resolved. If a particular post helped resolve your issue, please consider marking it as the accepted solution. This can be valuable to other community members who may encounter the same problem.

Thanks again for your contribution!