AX in Power BI Service Model view: editor appends .[Date], causing “The syntax for ‘;’ is incorrect”

Hi SamHE ,

Thanks for reaching out to Microsoft Fabric Community.

Thanks for the detailed repro and for documenting the behavior clearly.

The guidance shared earlier by lbendlin about disabling Auto Date/Time is correct when the model is authored or modified using Power BI Desktop, as that setting is only available there.

For models created and edited only in Power BI Service, there is currently no editor setting available to stop the auto insert of hierarchy members such as .[Date] while keeping IntelliSense enabled. This behavior is a limitation of the Service DAX editor.

Auto date/time in Power BI Desktop - Power BI | Microsoft Learn

From a best practices perspective, when authoring models or calculated columns in Service:

->Prefer explicit date columns or a dedicated date table rather than relying on implicit date hierarchies

->Keep date comparisons simple and explicit to avoid hierarchy member insertion

->Use consistent patterns for calculated columns to reduce editor side rewrites

Given this limitation, the workarounds you listed, such as using a VAR based pattern or confirming the column reference ends at ], are the recommended approaches for handling this behavior when authoring calculated columns directly in the Service.

Thanks for sharing those workarounds along with the repro steps.

Hope this helps. Please reach out for further assistance.
Thank you.