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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

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
Anonymous
Not applicable

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

Anonymous
Not applicable

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, @Anonymous ;
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 (perficient.com)

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
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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