cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jracer007 Member
Member

Date format Google analytics

Hello Community, I wanted to ask you how I change the format of the Google Analytics dates so that the Power BI does not recognize it as a number.

power bi3.png

1 ACCEPTED SOLUTION

Accepted Solutions
nik_yevsey Frequent Visitor
Frequent Visitor

Re: Date format Google analytics

I've used a long way: get 3 separate columns: day, month, year.

Convert them into text.

Merge into single column with dots or dashes between columns.

Convert into date format.

8 REPLIES 8
Community Support Team
Community Support Team

Re: Date format Google analytics

Hi @jracer007,

 

You can change data type in Query Editor mode.

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jracer007 Member
Member

Re: Date format Google analytics

It marks me error in the fields.

Community Support Team
Community Support Team

Re: Date format Google analytics

Hi @jracer007,

 

What error message did you get? What is the date formate like in Google Analytics?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
jracer007 Member
Member

Re: Date format Google analytics

The format is yyyyMMdd

nik_yevsey Frequent Visitor
Frequent Visitor

Re: Date format Google analytics

The same for me - date from Google Analytics comes in YYYYMMDD format and I cant find locale or some handy way to convert it into data type in PBI

nik_yevsey Frequent Visitor
Frequent Visitor

Re: Date format Google analytics

I've used a long way: get 3 separate columns: day, month, year.

Convert them into text.

Merge into single column with dots or dashes between columns.

Convert into date format.

jracer007 Member
Member

Re: Date format Google analytics

Thanks, I'll try with that if it works.

jracer007 Member
Member

Re: Date format Google analytics

How did you unite them?

power bi7.png