Forum Discussion

Griplock's avatar
Griplock
New Member
8 years ago

Adobe Analytics Connector

I am able to use segments in Workspace. However, when using the same segements in the Adobe Connector, there is an error stating that the "table is empty"
MMarquezs1991's avatar
MMarquezs1991
Regular Visitor
6 years ago

Hello jeffshieldsdev ,

Do you happen to know if this was included in the August Release? I'm pulling a very large data set, but the Power BI Adobe Analytics API times out still, unless I'm adding your logic incorrectly within the Advanced Editor.

jeffshieldsdev's avatar
jeffshieldsdev
Solution Sage
6 years ago

Queries can still timeout without error...the bug was that the two parameters "MaxRetryCount" and "RetryInterval" were ignored completely.  They now control the behavior of the connector.

  • MMarquezs1991's avatar
    MMarquezs1991
    Regular Visitor
    6 years ago

    Thanks jeffshieldsdev ! It's probably timing out due to complex and large data pull I'm requesting from the API

     

    Am I placing the Retry Inverval correctly below? I just want to confirm this I'm using it correctly since I'm very new to Power BI Query.

     

    let
    Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),
    toyota = Source{[Name="xxxxxxxx"]}[Data],
    tmstoyota2017 = toyota{[Id="xxxxxxxxxx"]}[Data],
    #"Retry Interval" = AdobeAnalytics.Cubes([RetryInterval = #duration(0, 0, 0, 20)]),
    #"Added Items" = Cube.Transform(xxxxxxxxx,
    {
    {Cube.ApplyParameter, "DateRange", {Date.AddMonths(Date.StartOfMonth(Date.From(DateTime.LocalNow())), -23),Date.AddMonths(Date.StartOfMonth(Date.From(DateTime.LocalNow())), -1)}},
    {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
    {Cube.AddAndExpandDimensionColumn, "xxxxxxxxxxx", {"xxxxxxxxxxx"}, {"xxxxxxxxxxx"}},
    {Cube.AddAndExpandDimensionColumn, "xxxxxxxxxxx", {"xxxxxxxxxxx"}, {"xxxxxxxxxxx"}},
    {Cube.AddAndExpandDimensionColumn, "xxxxxxxxxxx", {"xxxxxxxxxxx"}, {"xxxxxxxxxxx"}},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"},
    {Cube.AddMeasureColumn, "xxxxxxxxxxx", "xxxxxxxxxxx"}
    })


    in
    #"Added Items"

    • jeffshieldsdev's avatar
      jeffshieldsdev
      Solution Sage
      6 years ago

      Close...you only need one AdobeAnalytics.Cubes() function, not two seperate ones--just add the duration to the first one (no need for the #"Retry Interval" step you've added).

      I think your code should look like this:

      Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true, RetryInterval = #duration(0, 0, 0, 20)]),
      toyota = Source{[Name="xxxxxxxx"]}[Data],
      tmstoyota2017 = toyota{[Id="xxxxxxxxxx"]}[Data],
      #"Added Items" = Cube.Transform(xxxxxxxxx,

       This will check every 20 seconds for a result set--I would use maybe a minute:

      RetryInterval = #duration(0, 0, 1, 0)

       You can also use the MaxRetryCount to change how many times it'll check (the default is 120 times):

      Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true, RetryInterval = #duration(0, 0, 1, 0), MaxRetryCount = 60]),
      • MMarquezs1991's avatar
        MMarquezs1991
        Regular Visitor
        6 years ago

        Thank you for the feedback jeffshieldsdev ,

         

        Initially I ran into an error, but was fixed when I updated to the latest version of Power BI (Nov 2019) and your updates ran smoothly. However, the data set is still way too large for this method, so I'll need to find another method. Thanks again!