3 Replies Latest reply on Jul 18, 2018 8:08 AM by thomase92025994

    Adobe and Power BI connector

    thomase92025994 Level 1

      I'm having problems with using the Adobe and Power BI desktop connector. I asked in the Power BI forums and was told that the issues are due to limitations from the Adobe API. I am hoping to get some answers to some questions or to get some work arounds for some issues.

       

      1. Only a few of my segments appear in the navigator tool. I have created a few segments recently in Adobe and none of them are showing up to use as parameters. Currently I have to get the segment ID and then manually enter them into the advanced editor window.

       

      2. Is there a row limit in the connector? I can only get around 200,000 rows of data without getting a "Table is blank" error.

       

      3.  What are the best ways to filter data? I am attempting to use query folding to save load time and because of the reason above, but most filtering that I can currently do is happening after all the data is loaded into Power BI.

       

      4. It appears that my TOP filter is always on, even if I do not apply anything with this parameter. Once I choose a dimension, only 10 values will turn up. I want all of the values for the dimension to show up.

       

      If anybody could answer any or all of these questions, it would be much appreciated!

        • 1. Re: Adobe and Power BI connector
          cwra007 Level 1

          Not super helpful, but here is what I know:

           

          1. Had the same issue here too. I know the segments are specific to the report suite, and some newly created ones took a while to appear in the UI. Used the same workaround as you, directly editing the M code

          2. Adobe API doesn't have a limit, but PowerBI does tend to timeout if the request is to large. I haven't found a solve here, but I do use Postman GitHub - Adobe-Experience-Cloud/analytics-1.4-apis: Documentation and helpful resources for calling the Analytics 1.4 Ap… to monitor the Queue and the estimated time to completion. I have also wrapped most of my queries into smaller ones, looping through date ranges via PowerQuery functions. Postman can also give you a list of all the segment IDs via the Segments.Get method

          3. I do almost all of my filtering within the Query Editor client side. I don't think that query folding would speed up the pull, as Adobe data doesn't sit in a relational db.

          4. {Cube.ApplyParameter, "Top", {50, null}} - This give the top 50 dimensions. Any value works here

          2 people found this helpful
          • 2. Re: Adobe and Power BI connector
            kvotient Level 1

            I have the same issue in that I'm not seeing any segments at all in the navigator tool.  Would it be possible to share the M code you used to apply known segments to your metrics?  I'm new to Power BI and haven't found any documentation for Adobe-specific M code.

            • 3. Re: Adobe and Power BI connector
              thomase92025994 Level 1

              {Cube.ApplyParameter, "Segment", {{"sdfasdf"}}}

              This can be found in the advanced editor while in power query mode. The segment ID for a segment is at the end of the URL while viewing the segment in Adobe.

               

              let

                  Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),

                  #"xxxxxxxxxxxxxxl" = Source{[Name="xxxxxxxxx"]}[Data],

                  xxglobaldata = #"xxxxxxxxxxx"{[Id="xxglobaldata"]}[Data],

                  #"Added Items" = Cube.Transform(xxglobaldata,

                      {

                          {Cube.ApplyParameter, "DateRange", {#date(2018, 1, 1), #date(2018, 12, 31)}},

                          {Cube.ApplyParameter, "Segment", {{"s3751_59b0261db5e1f3sdff9b8d34", "s3751_596d0cdba5bb577e470c1111","s3751_5b3f6befa5bb5727e6de1sdf"}}},

                          {Cube.ApplyParameter, "Top", {700, "page"}},

                          {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},

                          {Cube.AddAndExpandDimensionColumn, "page", {"page"}, {"Page"}},

                          {Cube.AddMeasureColumn, "Visits", "visits"}

                      }),

                     #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Added Items", {{"Date Granularity.Level 2: Month", type text}, {"Date Granularity.Level 3: Day", type text}, {"Date Granularity.Level 1: Year", type text}}, "en-US"),{"Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day", "Date Granularity.Level 1: Year"},Combiner.CombineTextByDelimiter("/", QuoteStyle.None),"Date"),

                  #"Changed Type" = Table.TransformColumnTypes(#"Merged Columns",{{"Date", type date}})

              in

                  #"Changed Type"