microsoft / semantic-link-labs

Early access to new features for Microsoft Fabric's Semantic Link.
MIT License
178 stars 37 forks source link

Migration to Direct Lake - DateTime columns #243

Closed carlyrg closed 3 weeks ago

carlyrg commented 3 weeks ago

Using the notebook to convert import mode semantic model to Direct Lake in Fabric I'm getting number of unsupported items related to relationships between columns being of DateTime format. However they are defined as 'Date' in power bi and formatted as short date in the model and even in the SQL source table they are defined as a 'Date' data type. How do I get these columns to be recognized as Dates so the relationships can be created?

Image

Image

m-kovalsky commented 3 weeks ago

As of 0.8.4 this restriction is removed.


From: Carly Gerhart @.> Sent: Wednesday, October 30, 2024 4:25:10 PM To: microsoft/semantic-link-labs @.> Cc: Subscribed @.***> Subject: [microsoft/semantic-link-labs] Migration to Direct Lake - DateTime columns (Issue #243)

Using the notebook to convert import mode semantic model to Direct Lake in Fabric I'm getting number of unsupported items related to relationships between columns being of DateTime format. However they are defined as 'Date' in power bi and formatted as short date in the model and even in the SQL source table they are defined as a 'Date' data type. How do I get these columns to be recognized as Dates so the relationships can be created?

image.png (view on web)https://github.com/user-attachments/assets/f7b6612c-aa03-4805-b31f-58a3fd7e3d52

image.png (view on web)https://github.com/user-attachments/assets/14d56dbc-ce31-462f-919b-269c2940422f

— Reply to this email directly, view it on GitHubhttps://github.com/microsoft/semantic-link-labs/issues/243, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AHBQBNV6ITUYE7IOLT4NDZTZ6D25NAVCNFSM6AAAAABQ4MBRNWVHI2DSMVQWIX3LMV43ASLTON2WKOZSGYZDINBXGA4DONY. You are receiving this because you are subscribed to this thread.Message ID: @.***>

carlyrg commented 3 weeks ago

Thank you for the response and update

m-kovalsky commented 3 weeks ago

0.8.4