Different time format from Google Analytics data in Power BI Desktop

[Ewelina]

Hi, 

I have worked on data from Google Analytics and I have a problem with time (e.g. time on page) format. 

Before loading data from Analytics, it looks like a normal time format (e.g. 0.00:01:55.2307692).

In Power Bi Desktop, time looks different (e.g. 0,70 or 0,00, usually 0,00).

I would like to have a normal time format to know how much time somebody was on my page.

Please help me with this problem.

Thanks,

Ewelina

[v-piga-msft]

Hi @Ewelina,

Have you solved your problem?

If you have solved, could you please share the solution or always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please feel free to ask.

Best Regards,

Cherry

[RuiNDias]

Hi @v-piga-msft 

I had the same problem as @Ewelina.

Here is my pbix file, if you want to check.

Do you have any idea, why this happens?

Many thanks

[v-piga-msft]

Hi @Ewelina,

Please check if the date column your get from Google Analytics is the Text type in Power BI?

What if the format of your date column from Google Analytics? Could you share some screenshots to describe it in details?

I cannot reproduce your date format like 0.00:01:55.2307692 with my Google Analytics data.

If it is convenient, could you share a dummy pbix file which can reproduce the your scenario and your desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

Best Regards,

Cherry