cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Albsangon1
Frequent Visitor

Cross-report drillthrough not working.

Hello everyone.

 

I have followed every step in setting up the cross-report drilltrough, but to no avail. I must be missing something because it is not working.

I have two very simple reports, "Drillthrough 1" and "Drillthrough 2". I want to go from 1 to 2.

 

Capture of 1:

 

Albsangon1_0-1669806558164.png

 

Capture of 2:

 

Albsangon1_1-1669806593409.png

 

(In 1, I have tried the "cross-report" both on and off since I have found contradictory information).

 

In both files, the option is ticked:

 

Albsangon1_2-1669806647890.png

 

 

However, after publishing the files to my workspace, the option does not appear!!!

 

Albsangon1_3-1669806769761.png

 

 

I must be missing something obvious, since there are many post that say these are all the steps to take. Could someone please offer some help?

 

Many thanks in advace,

Alberto.

 

1 ACCEPTED SOLUTION
Albsangon1
Frequent Visitor

For anyone encountering the same problem in the future, I can confirm that this funcionality is not working in "my workspace".

Having done exactly the same in a different workspace, it works perfectly.

 

Cheers,

Alberto.

View solution in original post

3 REPLIES 3
Albsangon1
Frequent Visitor

For anyone encountering the same problem in the future, I can confirm that this funcionality is not working in "my workspace".

Having done exactly the same in a different workspace, it works perfectly.

 

Cheers,

Alberto.

Albsangon1
Frequent Visitor

Thank you for your answer.

 

They are both published in "my workspace". However, I've come to believe this is exactly the problem, that "my workspace" has this capability capped somehow (although I haven't found any documentation in this regard).

 

I will post again once I'm 100% sure.

v-yalanwu-msft
Community Support
Community Support

Hi, @Albsangon1 ;
Important points to note:

Both these report sources and targets must be in the same workspace.
The table and the column names must be exactly the same across both of those reports.
If you set Keep all filters to ON when you set up the target page, filter context from the source visual can include the following:
Report, page, and visual level filters that affect the source visual.
Cross-filter and cross-highlighting affect the source visual.
Slicers and sync-slicers on the page.
URL parameters.

 

you need publish to service and same work space.

Power BI - Cross-Report Drillthrough From One Report To Another Report For Increased Security (perfi...

Cross Report Drill-throughs MADE EASY! // Power BI - YouTube


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Dev Camp Session 30

Ted's Dev Camp - January 26, 2023

This session will provide guidance and teach campers the skills required to build Power BI reports that support multiple languages.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.