[BUG] Power BI Connector cannot read int64 Timestamp Columns

[aersam]

Bug

Describe the problem

Steps to reproduce

1. Create a Test File (here using Databricks)

spark.conf.set("spark.sql.parquet.outputTimestampType", "TIMESTAMP_MILLIS")
spark.sql("create table test_data using delta location 'abfss://MYPATH/repo/test';")

from datetime import datetime, timezone
spark.createDataFrame([{"date": datetime.now(tz=timezone.utc)}]).write.option("mergeSchema", "true").mode("append").save(MYPATH)

The resulting delta file: repo.zip

2. Read it using fn_ReadDeltaTable in Power BI:

let
    Source = AzureStorage.DataLake("MYPATH", [HierarchicalNavigation = false]),
    DeltaTable = fn_ReadDeltaTable(Source)
in
    DeltaTable

Observed results

Column is empty:

Expected results

Column should correctly display the data, as does databricks

Willingness to contribute

The Delta Lake Community encourages bug fix contributions. Would you or another member of your organization be willing to contribute a fix for this bug to the Delta Lake code base?

• Yes. I can contribute a fix for this bug independently.
• Yes. I would be willing to contribute a fix for this bug with guidance from the Delta Lake community.
• No. I cannot contribute a bug fix at this time.

I have to admit I don't really understand the Power Query Code of the Connector :)

[aersam]

FYI: Reading the parquet directly in power bi does work