Forum Discussion
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...
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:
Hi BhavaniK ,
Hope you're doing okay! May we know if it worked for you, or are you still experiencing difficulties? Let us know — your feedback can really help others in the same situation.