Adobe Analytics 2.0 error

[Arnerud]

I receive an errror og date or datetime when i try to load data from adobe analytics connector into powerBI desktop. I know that there is som edate issues with the 2.0 (beta) connector, but have anyone manage to solve this error? It wont work with year, month, day or any of the date fields. 

[v-yangliu-msft]

Hi  @Arnerud ,

In general, such an error occurs when a date field in an Adobe Analytics data source is not recognized as a date or datetime data type.

You can try the following:

In Power Query, select the date column that caused the error, select Data Type, and convert it to "Date" or "Datetime".

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Arnerud]

Thank you for the reply. The problem is that I don't get the data into Power Query and transform it. I solved the error above

I get here and when I try to add a metric I get a new error:

When I remove year as the "Date Granularity" I'm able to transform the data. But then the API take ages to load the data before I can transform it.