Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Since Friday February 19th the following issue has been occuring:
When performing a cross-report drill through for which the target report consists of multiple pages, it always lands on the same page, no matter which page was chosen when drilling through. In particular, the page that gets shown when drilling through seems to be the page that was first created in the target report, even if this page has not been set up as a drill through target. Before Friday everything worked fine and no changes have been made to the report. I have tried using different browsers (Chrome and Edge), but this did not solve the problem. Using a previous version of PBI Desktop (Nov 2020) hasn't worked either.
For example, I have a simple report called 'Drillthrough' with pages 'See Column1', 'See Column2' and 'See Column3'. For each of these pages a cross-report drill through field has been set up. When I try to drill through to the page 'See Column2' (starting from a different report that is based on the same dataset), I am brought to the page 'See Column1' instead. The same happens when I try to drill through to the page 'See Column3'. This is illustrated in the following screenshots:
When the reports are put together in an app and the cross-report drill through is performed in the app, the correct page is briefly selected before jumping to the wrong one.
As some extra info, the queries that are sent to the database when performing the drill through are included below (drilling through to page 'See Column3' after right-clicking on the first row of the table):
// DAX query against Database: MasterTable
DEFINE
VAR __DS0FilterTable =
TREATAS({"C"}, 'MasterTable'[Column3])
VAR __DS0Core =
CALCULATETABLE(
SUMMARIZE('MasterTable', 'MasterTable'[Column1], 'MasterTable'[Column2], 'MasterTable'[Column3]),
KEEPFILTERS(__DS0FilterTable)
)
VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
'MasterTable'[Column1],
1,
'MasterTable'[Column2],
1,
'MasterTable'[Column3],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
'MasterTable'[Column1], 'MasterTable'[Column2], 'MasterTable'[Column3]
// DAX query against Database: MasterTable
DEFINE VAR __DS0FilterTable =
TREATAS({"C"}, 'MasterTable'[Column3])
EVALUATE
SUMMARIZECOLUMNS(
__DS0FilterTable,
"MinColumn1", IGNORE(CALCULATE(MIN('MasterTable'[Column1])))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.