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 are doing great. May we know if your issue is solved or if you are still experiencing difficulties. Please share the details as it will help the community, especially others with similar issues.