Forum Discussion
Drill-through Not Working Between Pages Using Different Data Sources in Power BI
Thanks to johnbasha33 for always helping the community!
The drill-through doesn’t work because Power BI requires the same exact field from the same table (not just identical columns) to pass filter context between pages.
- Simple Fix:
Use the combined UNION ALL table as the main table for both report pages. Then, use that table’s fields (like CustomerID, etc.) for both the visuals and the drill-through target field.
Only fields from the same table can be used in drill-through — even if column names are identical across tables.
Hope this helps! If yes, please give kudos and accept as solution.
- Simple Fix:
Thanks to johnbasha33 for always helping the community!
The drill-through doesn’t work because Power BI requires the same exact field from the same table (not just identical columns) to pass filter context between pages.
- Simple Fix:
Use the combined UNION ALL table as the main table for both report pages. Then, use that table’s fields (like CustomerID, etc.) for both the visuals and the drill-through target field.
Only fields from the same table can be used in drill-through — even if column names are identical across tables.
Hope this helps! If yes, please give kudos and accept as solution.