Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Incremental refresh - data source Adobe Analytics

Hello,

I am at the very beginning as PowerBI user. I try the incremental recfresh on a sample of my data provided by Adobe Analytics source

 

= Cube.Transform(myreportsuitename,
{
{Cube.ApplyParameter, "DateRange", {#date(2022, 1, 3), #date(2022, 1, 16)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
{Cube.AddAndExpandDimensionColumn, "prop2", {"prop2"}, {"Custom Insight 2"}},
{Cube.AddAndExpandDimensionColumn, "mobiledevicetype", {"mobiledevicetype"}, {"Device Type"}},
{Cube.AddAndExpandDimensionColumn, "prop25", {"prop25"}, {"Groupe"}},
{Cube.AddAndExpandDimensionColumn, "page", {"page"}, {"Page"}},
{Cube.AddMeasureColumn, "Visits", "visits"},
{Cube.ApplyParameter, "Segment", {{"s1951_61432c91f2d98f38f410dafc"}}}
})

 

I made the data column

= Table.AddColumn(#"Éléments ajoutés", "Date_trafic", each #date([#"Date Granularity.Level 1: Year"],[#"Date Granularity.Level 2: Month"],[#"Date Granularity.Level 3: Day"]))

 

and the parameters, filtered, published

 

= Table.AddColumn(#"Éléments ajoutés", "Date_trafic", each #date([#"Date Granularity.Level 1: Year"],[#"Date Granularity.Level 2: Month"],[#"Date Granularity.Level 3: Day"]))

 

But though I can see the parameters, the incremental refresh is not active : the message I can see is about the parameters to set up.

 

 

Can you help ? Is this feature is avalaible for Pro users ?

 

Thank you !

Maria

 

  • Hi. The feature is still for pro. The problem to keep in mind is that in the feature considerations you can read that the feature was built to work with sources that can apply query folding. Adobe analytics might not fold.

    However the community has proved to avoid that limitations for some sources like sharepoint.

    I think this can help you because it is the first time I have seen a person able to build an incremental refresh from a non foldable source.

    https://www.esbrina-ba.com/incrementally-load-from-sap-apis-or-almost-anything/

    I hope that helps,

1 Reply

  • Hi. The feature is still for pro. The problem to keep in mind is that in the feature considerations you can read that the feature was built to work with sources that can apply query folding. Adobe analytics might not fold.

    However the community has proved to avoid that limitations for some sources like sharepoint.

    I think this can help you because it is the first time I have seen a person able to build an incremental refresh from a non foldable source.

    https://www.esbrina-ba.com/incrementally-load-from-sap-apis-or-almost-anything/

    I hope that helps,