Add support for microsecond (6-digit) datetime precision across Eventhouse, Lakehouse, and Shortcuts
Description:
We are currently using Microsoft Fabric with Eventhouse -> Shortcut -> Lakehouse -> Snowflake Iceberg architecture. We have observed that datetime values are stored with millisecond precision (3 digits), for example:
2025-05-03 08:09:34.301
However, downstream systems like Snowflake Iceberg require microsecond precision (6 digits), such as:
2025-05-03 08:09:34.301000
This mismatch leads to compatibility issues when reading Fabric-generated Parquet files in Iceberg tables.
Current behavior:
Fabric stores datetime values with millisecond precision (scale 3), and there is no built-in way to enforce or convert to microsecond precision.
Expected behavior:
Fabric should support configurable datetime precision (e.g., 3, 6 digits) or automatically pad milliseconds to microseconds when required, ensuring compatibility with downstream systems like Iceberg.
Impact:
This is a critical blocker for integrating Fabric Lakehouse with modern data platforms like Snowflake Iceberg and affects enterprise adoption of Fabric in production environments.
Recent ideas
Variable Library: Disable default value set.
The Default Value Set in the Variable Library poses a risk. The Default Value Set will silently apply values when no explicit value set has been selected for a Test or Prod workspace. There i...frithjof_v6 hours agoCommunity ChampionNew634Views17likes2CommentsScheduled Refresh for Fabric Mirroring
Current Challenge: Fabric Mirroring runs continuously, leading to unnecessary data replication and higher Snowflake costs. There is no built-in option to schedule mirroring based on specific times o...ram_eternal1897 hours agoRegular VisitorNeeds Votes472Views3likes2CommentsMake workspace and item session persistence optional
Description The new persistent session behavior in Microsoft Fabric should be optional rather than forced. Currently, Fabric remembers the workspaces and items that were open in my previous session...TeemuMultanen8 hours agoAdvocate INew265Views42likes1CommentWhy are Calculation Groups so hard to modify?
Is there a way to make it easier to modify the DAX in a calculation group? I'm not sure if it's just me that finds this so annoying, but perhaps it's because I just started using calculation groups. ...AaronReasoner10 hours agoNew MemberNew9Views0likes0CommentsFeature Request: Add a Warning Prompt Before Deleting Tables That Contain Measures
Problem Statement: In Power BI, measures are linked to specific tables. When a developer deletes a table from the model view or report view, Power BI automatically deletes all measures assigned to ...Murtaza_Ghafoor12 hours agoSuper UserNew17Views2likes0Comments