Date format Google analytics

[jracer007]

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.

[nik_yevsey]

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

[v-yulgu-msft]

Hi @jracer007,

You can change data type in Query Editor mode.

Best regards,

Yuliana Gu

[nik_yevsey · Accepted solution]

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]

How did you unite them?

[jracer007]

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

[jracer007]

It marks me error in the fields.

[v-yulgu-msft]

Hi @jracer007,

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

Regards,

Yuliana Gu

[jracer007]

The format is yyyyMMdd