Drill-through on date/datetime datatype not showing when create report from another semantic model

Thankyou, Akash_Varuna, for your response.

Hi po,

We appreciate your inquiry through the Microsoft Fabric Community Forum.

Based on my understanding, this is a known behaviour in Power BI when working with semantic models across different workspaces, particularly with Date or DateTime fields. The metadata for these fields does not always align correctly in the consuming report, which prevents the drill-through option from appearing.

Kindly follow the workaround steps below that may help to resolve the issue:

1. In your semantic model (Workspace A), create a new calculated column:

  DateKey = FORMAT('YourTable'[YourDateField], "yyyy-MM-dd")

2. In your report (Workspace B), use this DateKey for both the source visual and the drill-through page.

3. Drag the DateKey into the Drill-through Fields pane.

4. Refresh both your dataset and report to ensure that the updated metadata is reflected.

5. Ensure that you are using a live connection and that both the source and target pages use the same data type and column.

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.

Thank you.