Forum Discussion
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"
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]),
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!