cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

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.

Status: Investigating

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

 

Comments
v-yetao1-msft
Community Support
Status changed to: Investigating

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