Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I have pulled Session duration from Google analytics. When I try to do aggregations on it, it is not working properly in Power BI. Duration is getting converted into a fixed decimal number while reporting. Is there any work around for this? Also, it looks like it is performing aggregations after converting it to fixed decimal number. Does anyone know what is the logic it is applying to convert duration into fixed decimal number internally? Below is the screenshot. In query editor it was showing properly as a duration. However, In reporting model it was shown as a fixed decimal number.
Solved! Go to Solution.
If no further question, could you accept that reply as solution to close this thread.
For any question, feel free to post. 🙂
@RaviTejaLaxman wrote:
I have pulled Session duration from Google analytics. When I try to do aggregations on it, it is not working properly in Power BI. Duration is getting converted into a fixed decimal number while reporting. Is there any work around for this? Also, it looks like it is performing aggregations after converting it to fixed decimal number. Does anyone know what is the logic it is applying to convert duration into fixed decimal number internally? Below is the screenshot. In query editor it was showing properly as a duration. However, In reporting model it was shown as a fixed decimal number.
I'd say it is by design. There's no such "duration" type in reporting end. The logic is simple, the fraction part .1206597222*24*60*60 = 10,425 seconds, which is the same as "02:53:45". If you do care about the presentation text, check this thread Aggregating Duration/Time.
Thanks Eric, It worked
If no further question, could you accept that reply as solution to close this thread.
For any question, feel free to post. 🙂
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the September 2025 Power BI update to learn about new features.