Starburst timestamp(9) not supported date type in Power BI

[QueenTink]

We are wanting to use direct query for our datasets so we are not limited to how often we can refresh an imported dataset. We are running into an issue of with datetime fields coming from Starburst. Power BI doesn't support timestamp(9) as a date field and we are unable to convert the field data type due to the limitation of direct query. Are there any date formats from Starburst that Power BI supports? We haven't found any.

[Anonymous]

Hi  @QueenTink 

So the time taken from inside Starburst is in timestamp format right? Do you want to convert it to date format?

I found some similar cases , hope it can help you !

Power Query; Convert Time Stamp to Date Time - RADACAD

Solved: Power Query Timestamp - Microsoft Fabric Community

Best Regards,
Community Support Team _ Ailsa Tao