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.
Go to 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.
You can change data type in Query Editor mode.
It marks me error in the fields.
What error message did you get? What is the date formate like in Google Analytics?
The format is yyyyMMdd
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
Thanks, I'll try with that if it works.
How did you unite them?