Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Adobe Analytics 2.0 error

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. 



Community Support
Community Support

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.

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. 


Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors