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

[saumya3094]

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 than 600 rows

Data is populated in all table using Power Query that is applied over the Adobe Analytic API.

While for other table data is getting populated in less than 1 minute and no of rows are more than 15,000
After refreshing multiple data time is available on the Power BI desktop version but not on the Power BI services. Table is taking too long to load into the model when I have added date column in table for incremental refresh from Adobe Analytic tables using Cube.AddAndExpandDimensionColumn parameter. Also view native query is disabled for the applied step

Thanks

[Pradeep_V_P]

Hi,

Could you tell me how do you get a default date dimension for Adobe analytics.

It only has option to select granularity but not the exact date as a dimension.

This makes using a merge to get a date format a must. And wothout a proper date format, incirmental refresh is not  possible. ANy suggetions?

Regards

PRadeep

[Anonymous]

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

[saumya3094]

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]

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