Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

5 REPLIES 5
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.

Thank you this solved the problem.

 

I have been stuck on this very same issue with publishing on 'my workspace'. It's resolved now. Many thanks

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors