Forum Discussion
Microsoft EmployeeFacing refresh issue from Adobe Analytic connector. Data is loading in model after multiple refresh
HI saumya3094,
Any advanced operations in your query tables? (e.g. merge, combine, reference other queries, invoke custom functions...) AFAIK, they will increase the memory spend processing time on looping calculations.
Please take a look at following link about buffer functions if they suitable for your scenario:
How and When to use List & Table Buffer?
Regards,
Xiaoxin Sheng
Microsoft Employeelet
Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),
#"microsoft store" = Source{[Name="microsoft store"]}[Data],
msftenterprisecloudprod = #"microsoft store"{[Id="Source"]}[Data],
currentDate = DateTime.FixedLocalNow(),
#"Added Items" = Cube.Transform(msftenterprisecloudprod,
{{Cube.ApplyParameter, "DateRange", {DateTime.Date(Date.AddDays(currentDate, -30)) ,DateTime.Date(Date.AddDays(currentDate, 1))}},
{Cube.ApplyParameter, "Segment", {{"123"}}},
{Cube.ApplyParameter, "Top", {1000, null}},
{Cube.AddAndExpandDimensionColumn, "evar15", {"evar15"}, {"Page Title (v15)"}},
{Cube.AddAndExpandDimensionColumn, "evar41", {"evar41"}, {"Page URL (No Query Strings) (v41)"}}
}),
#"Removed Duplicates" = Table.Distinct(#"Added Items", {"Page URL (No Query Strings) (v41)"}),
#"Trimmed Text" = Table.TransformColumns(#"Removed Duplicates",{{"Page Title (v15)", Text.Trim, type text}}),
#"Replaced Value" = Table.ReplaceValue(#"Trimmed Text"," | Microsoft Docs","",Replacer.ReplaceText,{"Page Title (v15)"}),
#"Renamed Columns" = Table.RenameColumns(#"Replaced Value",{{"Page Title (v15)", "Article"}})
in
#"Renamed Columns"
HI saumya3094,
I check your code but not found any unusual steps, so I think your issue should more relate to the connection from power bi to data source. Please contact to power bi or adobe analytic support to confirm if anything incompatibility in these data transforms/connection steps.
You can also take a look at the support page if the listed known issue meets your scenario.
https://powerbi.microsoft.com/en-us/support/
Regards,
Xiaoxin Sheng