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?
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.