Power BI connector for Adobe not fetching data in right format

[Singh13]

I have been trying to fetch data into Power BI using Adobe connector 2,0 version but every time I get error when I select year as one of the columns. I called Microsoft and they said that Adobe API is returning year in a format that is not understandable to Power BI.

Any help will be appreciated. Thanks.

[f_husain]

Hey @Singh13  

If you're still getting this error, please check your report suite calendar setting in Adobe Analytics.

If you're using Modified Gregorian Calendar it would render the date in format something like - 2023 (Jan 1 - Dec 31) which is something not supported by Power BI it seems.

The default Gregorian calendar setting renders in YYYY format and hence it will work in this case.

Hope this helps.