Expand my Community achievements bar.

The Analytics Community Lens news letter for February 2024 is now here! Come see upcoming events and what's been going on in the community!

Power BI connector for Adobe not fetching data in right format

Avatar

Level 1

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.

Singh13_0-1686920733527.png

 

Any help will be appreciated. Thanks.

 

1 Reply

Avatar

Level 3

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.