DateTime Error for Adobe Analytics Connector 2.0

[Shoopa]

I'm getting a new error back from the Adobe Analytics connector 2.0.  It says that the string was not recognized as a valid DateTime.  The weird thing is that this happened to an existing report that's been working for months.  It appears to be tied directly to the Date Granularity portion of the code:

section Section1;

shared #"xxxxxxxxxxx" = let
Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),
xxxx = Source{[Name="xxx"]}[Data],
xxxxxxxxx = xxx{[Id="xxx"]}[Data],
#"Added Items" = Cube.Transform(xxx,
{
{Cube.ApplyParameter, "DateRange", {#date(2022, 6, 8), #date(2022, 6, 8)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
{Cube.AddMeasureColumn, "Visits", "visits"}
})
in
#"Added Items";

shared #"NavigatorBase_c824bbff-c5c4-4018-a767-e917f280cc3e" = let
Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true, Implementation="2.0"])
in
Source;

error details below:

Feedback Type:
Frown (Error)

Timestamp:2022-06-08T17:54:12.2780074Z

Local Time:2022-06-08T13:54:12.2780074-04:00

Session ID:dbfe88b2-189d-4606-9878-1e7ccc333c54

Release:May 2022

Product Version:2.105.1143.0 (22.05) (x64)

Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
Microsoft.Mashup.Evaluator.Interface.ErrorException: String was not recognized as a valid DateTime. --->  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.MoveNext()
at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()
at System.Linq.Buffer`1..ctor(IEnumerable`1 source)
at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source)
at Microsoft.Mashup.Engine1.Runtime.Library.List.BufferFunctionValue.TypedInvoke(ListValue list)
at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue1`2.Invoke(Value arg0)
at Microsoft.Mashup.Engine1.Runtime.TableValue.BufferedTableValue.BufferTable(TableValue table)
at Microsoft.Mashup.Engine1.Runtime.TableValue.Buffer(BufferMode bufferMode)
at Microsoft.Mashup.Engine1.Runtime.WrappingTableValue.Buffer(BufferMode bufferMode)
at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.BufferFunctionValue.TypedInvoke(TableValue table, Value options)
at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame)
at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame)


at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name)
at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index)
at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0)

at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index)
at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
--- End of inner exception stack trace ---

at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)

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.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception)
at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback)
at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback)
at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters)
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.RemoteDocumentEvaluator.Service.<>c__DisplayClass9_1.<OnBeginGetPreviewValueSource>b__1()
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__DisplayClass17_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_Value()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value()
at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__DisplayClass22_0.<StartEvaluation>b__0(EvaluationResult2`1 result)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.105.1143.0","ModuleName":"","Component":"Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsDateGranularityHierarchyV2.<>c.<","Error":"System.FormatException","MethodDef":"cctor>b__9_0","ErrorOffset":""}

OS Version:
Microsoft Windows NT 10.0.19042.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
54.5 GB

Private Memory:
860 MB

Peak Working Set:
1.1 GB

IE Version:
11.789.19041.0

User ID:
8c6c8de9-e1fe-4e86-9f12-b55fb64e4e04

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-cazheng-msft]

Hi @Shoopa,

May I know what’s the data format of your date/time column in your original data source? How you set the data type in Power BI?

Best Regards,

Community Support Team _ Caiyun

[Shoopa]

Hi, 

I'm using the Adobe Analytics 2.0 (Beta) data connection: 

When I pull in the date, it pulls by year, month, day in separate columns, like below. 

The mquery looks like this: 

{Cube.ApplyParameter, "DateRange", {#date(2022, 6, 8), #date(2022, 6, 8)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"variables/daterangeyear", "variables/daterangemonth", "variables/daterangeday"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},

This method has worked for more than a year and only just recently started prompting the error.  I've tried it before and after an update.  Other colleagues have had the same issue.  This error pops up for existing connections when trying to refresh as well as when building a new connection as soon as I add a metric.

[Shoopa]

@v-cazheng-msft has there been any update on this issue?

[a_bertolett]

I get the exact same error. I can't get around it.

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.TryIncrementEnumerators(Int32 depth)
at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)

[tommy_8]

Hey all, Same here.

It's because of the year (variables/daterangeyear). In case, I only fetch Month and Day, it's working.

Who is in charge of the Adobe Analytics connector?

***

Unerwarteter Fehler.: Die Zeichenfolge wurde nicht als gültiges DateTime erkannt.
Details:
Microsoft.Mashup.Evaluator.Interface.ErrorException: Die Zeichenfolge wurde nicht als gültiges DateTime erkannt. ---> System.FormatException: Die Zeichenfolge wurde nicht als gültiges DateTime erkannt. ---> System.FormatException: Die Zeichenfolge wurde nicht als gültiges DateTime erkannt.
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsDateGranularityHierarchyV2.<>c.<.cctor>b__9_0(String s)
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.GetReportRows(RecordValue dataRecord, AdobeAnalyticsServiceV2 service, String companyId)
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.<GetReportNonZeroDimensions>d__27.MoveNext()
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth)
bei Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.MoveNext()
bei Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext()
bei Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
bei Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
bei Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
bei Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
bei Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1()
bei Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
bei Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
bei Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(String entryName, IEngineHost engineHost, IMessageChannel channel, Action action)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
bei Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
bei Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.EvaluationHost.Run()
bei Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
bei Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
bei Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
bei Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- Ende der internen Ausnahmestapelüberwachung ---
bei Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
bei Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
bei Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
bei Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
bei Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
bei Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)

***

best, Thomas

[rensb]

Any fix for this?

[Shoopa]

@rensb not so far.  @tommy_8  posted recently that the year is what's causing the issue. you can pull just the day and month and it will work.  I've set up my queries to pull the date range only within a calendar year and in the transform step, added the year.  then finally, you can append each year's data together in a new dataset.  has worked for me.

[fhusain]

Hey All,

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 calendar setting renders in YYYY format and hence it works. 

Hope this helps.

[ReportMaster]

Hi @Shoopa were you able to find a solution? I've used the Adobe native connector but I had some issues too. As a workaround, maybe you can try connecting your data with a 3rd party tool, this is why I currently do. 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

[Curious_PBI]

Hi everyone,

Do you have any news on this issue or any workaround (without using third-party tools)? I'm experiencing the same issue with a custom calendar (choice of my organization).

Thanks.