Power BI connector for Adobe not fetching data in right format | Community
Skip to main content
S
Singh13
June 16, 2023
Solved

Power BI connector for Adobe not fetching data in right format

  • June 16, 2023
  • 1 reply
  • 639 views

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.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by FarazHusain

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.

1 reply

FarazHusain
Adobe Employee
FarazHusainAdobe EmployeeAccepted solution
Adobe Employee
July 6, 2023

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.

Terms & ConditionsAccessibility statement

Loading footer...