Forum Discussion
Solved
Google Analytics time duration formatting issue
Hi guys, We are connecting Power BI Desktop to the Google Analytics online service, and are having an issue with the duration fields (e.g. Avg. Time on Page). On Google Analytics this is in the ...
Hi cmackay,
What's the data type that column? You can change the data type to Time.
Regards,
Charlie Liao
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-data-types/
Duration is the data type used when we first import our data and can view it as a type before we load the data. From there, Duration is converted into a decimal which we need to convert back.
Tom.