Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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:

 

 

Capture of 2:

 

 

(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:

 

 

 

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

 

 

 

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.

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

5 Replies

  • Anonymous's avatar
    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.

    • SIMMI's avatar
      SIMMI
      Frequent Visitor

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

    • ahr's avatar
      ahr
      New Member

      Thank you this solved the problem.

       

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    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.

  • Anonymous's avatar
    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.