Forum Discussion
Solved
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.
Hi jracer007,
What error message did you get? What is the date formate like in Google Analytics?
Regards,
Yuliana Gu
The format is yyyyMMdd