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 you dont have any issue. i request you to please accept the post that resolved your issue as the solution, this will help other community members who might face a similar issue.

     

    Thanks again for your contribution!