Forum Discussion
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
- AnonymousNot 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- AnonymousNot 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.
- AnonymousNot applicable
Anonymous,
You can share us dummy data of your table via Excel file when you reproduce this issue.
Regards,
Lydia