Forum Discussion

saumya3094's avatar
saumya3094
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

Facing refresh issue from Adobe Analytic connector. Data is loading in model after multiple refresh

Hi There, I am not able to refresh table data on the Power BI services. It’s taking more than 30 min to refresh the data for 1 month on Power BI desktop version 2.82. Table is not containing more th...
Interesting Links
Need Help
Show and Tell
saumya3094's avatar
saumya3094
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago

let
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"

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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