Hi Team,
We use the Starburst Enterprise connector and the DirectQuery mode to create a dataset. Everything works as expected in Power BI Desktop but all visuals based on columns of the Starburst time/timestamp data format are not displayed in Power BI Service. The data types are automatically converted when loading the data in Power BI Desktop (Starburst time -> PBI Time; Starburst timestamp -> Power BI DateTime).
If I only use columns with other data formats (except Starburst time or Starburst timestamp) in the visuals, there is no problem.
The driver version of the Starburst gateway is v2.1.2.1004, on both Power BI Desktop and Service.
If we use the "Import" option instead of "DirectQuery" everything works.
This is the error message we receive in Power BI Service:
Activity-ID: cfef115f-5e19-44c7-8d13-fb5f9827ecd4
Request-ID: b75022d2-dd9d-c8e2-3a7d-dc18b2fb4e2c
Correlation-ID: 68bed6fe-1d14-495c-a752-0630724f5a20
Time: Wed Dec 13 2023 15:14:31 GMT+0100
Service version: 13.0.22202.65
Client version: 2312.1.17115-train
Cluster-URI: https://wabi-north-europe-l-primary-redirect.analysis.windows.net/
We'd be glad for any advice!
