Issue with "Year" in Adobe Analytics 2.0 Connector

[pbelcher417]

Hi all, am having some issues with the Adobe Analytics 2.0 Connector in Power BI. Basically if I try to select "Year" in date granularity it always gives me the error below, effective saying it's not recognized as a valid datetime.

Works perfectly fine with the 1.0 Connector, but the 1.0 Connector doesn't have the ability to add segments as an attribute that the 2.0 connector does.

Unexpected error: String was not recognized as a valid DateTime.

Details:

    Microsoft.Mashup.Evaluator.Interface.ErrorException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime.

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsDateGranularityHierarchyV2.<>c.<.cctor>b__9_0(String s)

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.GetReportRows(RecordValue dataRecord, AdobeAnalyticsServiceV2 service, String companyId)

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.<GetReportNonZeroDimensions>d__27.MoveNext()

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)

   at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.MoveNext()

   at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()

   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)

   at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()

   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

   --- End of inner exception stack trace ---

   at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass11_0.<TryReportException>b__1()

   at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)

   at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)

   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)

   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()

   at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)

   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)

   at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)

   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.EvaluationHost.Run()

   at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)

   at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

   at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)

   at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)

   --- End of inner exception stack trace ---

   at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)

   at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)

   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)

   at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()

   at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

[v-cazheng-msft]

Hi @pbelcher417 

May I know whether 'Year' is a seperate column in your Adobe Analytics data source?

What kind of data type is this column in your data source? Is it a string?

Best Regards,

Community Support Team _Caiyun

[ReportGuru]

Hi @pbelcher417  were you able to find a solution? Seems like an issue related to the data type. As a workaround, maybe you can connect your data using a 3rd party connector. I've tried windsor.ai , supemetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder,  to make the connection first search for the Adobe connector in the data sources list:

Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link