Forum Discussion
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.
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
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
It marks me error in the fields.
Hi jracer007,
What error message did you get? What is the date formate like in Google Analytics?
Regards,
Yuliana Gu
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.
Thanks, I'll try with that if it works.
