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

[po]

Hi,

Have a semantic model in one workspace (workspace a) and created a report in workspace b using this semantic model.

However, when look to use drill-through specifically on a date or datetime datatype in report in workspace b the drill-through option isn't showing when right-click.

Drill-through option does show if use other datatypes.

Also drill-through shows if create report in workspace a using the date column.

Also noticed even if change column datatype in semantic model from dattime to date, it always shows as datetime format when create report in workspace b thus thought if have both as datetime then same datatype would work but still doesn't show drillthrouh option

It seems to be specific issue when try use drill-through in report in workspace on a date or datetime datatype.

Please can you advise if this is a bug or known issue and how best resolve?

Thanks

[v-pnaroju-msft]

Hi @po,

We kindly request you to mark your response as the accepted solution, as this will help other community members find answers to similar challenges more efficiently.
Please continue leveraging the Fabric Community for any further assistance with your queries.

Thank you.

[v-pnaroju-msft]

Hi @po,

Thankyou for the response.

We kindly request you to mark your response as the accepted solution, as this will help other community members find answers to similar challenges more efficiently.
Please continue leveraging the Fabric Community for any further assistance with your queries.

Thank you.

[v-pnaroju-msft]

Hi @po,

Thank you for sharing your insights and approach in resolving the issue.

We kindly request you to mark your response as the accepted solution, as this will help other community members find answers to similar challenges more efficiently.
Please continue leveraging the Fabric Community for any further assistance with your queries.

Thank you.

[po]

Thanks for replies.

Interstingly draggedd the date column in and out and started to behave as expected with drillthrough on the date available.    Will take yoir points above into account re calculated column if see thsi behaviour again.

[v-pnaroju-msft · Accepted solution]

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.

[Akash_Varuna]

Hi @po It might be because of inconsistencies in handling Date or DateTime fields across semantic models in different workspaces. Ensure the column data type in the semantic model is explicitly set, and confirm the drill-through field is correctly added in the Drill-Through Fields pane. As a workaround, create a calculated column (like a formatted DateKey) for drill-through. If the issue persists, refresh connections or contact Microsoft Support for help.

[po]

Thanks for replies