Forum Discussion
Cross Report Drill Through
Hi all
I´m trying to use Cross Report Drill Through but can´t get it to work.
- The two reports are in same WS
- They each have their own semantic model
- Columns used have same name and format UserID and Text, but tables have different names.
- Cross-report are on
- column are added to "drill through box" in report
- after publishing to WS I have toggled "Allow visuals in this report to use drill through targets from other reports" to on and refreshed the reports.
Still can´t get this to work Drill through does not appear when right clicking a value in a visual (have tried different visuals). If I set up a classic "in report" drill through, that will work, but not cross-report.
I have tested adding at table in power query with one column named kolumn 2 rows with values 0 and 1 format text, in both reports and tried setting up the cross-report drill through using them knowing they are exactly identical in always. still does not work.
I have also tester republishing reports togging on and off etc....
Fels like I´m missing something, anyone have an idea?
For cross-report drill through the fields must match on the fully qualified name Table[Column]. If your source and target reports use different table names, Power BI treats the fields as different even when the column name is the same. That is why the in-report drill through works but the cross-report one does not appear.
Rename the table in one of the models so both source and target expose the field with the same table name and the same column name (case sensitive), then republish.
Also double check that the drill through field on the target report has the Cross-report toggle turned on inside the drill through card, and that both reports are in the same workspace.
If this helped, a thumbs up and accepting the solution would be appreciated.
Thank you,
Shai Karmani
2 Replies
For cross-report drill through the fields must match on the fully qualified name Table[Column]. If your source and target reports use different table names, Power BI treats the fields as different even when the column name is the same. That is why the in-report drill through works but the cross-report one does not appear.
Rename the table in one of the models so both source and target expose the field with the same table name and the same column name (case sensitive), then republish.
Also double check that the drill through field on the target report has the Cross-report toggle turned on inside the drill through card, and that both reports are in the same workspace.
If this helped, a thumbs up and accepting the solution would be appreciated.
Thank you,
Shai KarmaniO my o my now it works!
My hero Shai_Karmani , it was the supid diffrent table names : )
Thanks for helping out
