Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Drilllthough sometimes does not pass filter

This one is hard to reproduce, but I have often seen that one row will go to the drill through page and not pass the filter.  I beleive this happens when a drillthrough has been used in the desktop edition, and published to the web with that filter in place and not (all).   Most of the rows work fine, but the occasional row will not connect and goes back to the one last used in desktop.   The fix is to go to desktop when this is discovered, erase the drillthrough filter, and republish.  Its very hard to avoid however as these are often used during testing.

 

As a fix, I would suggest resetting all Drillthrough filters to (All) at publishing or saving.  There really is no point in them retaining the setting beyond the actual use.

13 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    I am not able to reproduce your issue. Could you please share the problem PBIX file to me so that I can test?

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable

      I can't really do that as it uses an on premesis tabular with very confidential data that I cannot send.  It is so erratic that I don't know that I could reproduce, I just know that it comes up sometimes.  I'll try to monitor it to see if I can find any more clues, and if I get the pattern I can try to put together a small sample.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous,

        You can share us dummy data of your table via Excel file when you reproduce this issue.

        Regards,
        Lydia