https://biinsight.com/quick-tips-time-dimension-with-granularity-of-seconds-in-power-bi-and-analysis-services-tabular-models/
Quick Tips: Time Dimension with Granularity of Seconds in Power BI and Analysis Services Tabular Models