Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Reporting instances in Adobe Analytics

Hi All,

 

I have 2 production suites in Adobe Analytics. When I connect Power BI to Adobe Analytics, I see only one instance and missing out another instances. I tried to disconnect and reconnect Adobe Analytics but unforntunetly it shows only one. Can anyone help?

  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous,

    Have you checked that if there are any difference between your permission and your colleagues's permission in Adobe Analytics?

    You can firstly connect to the appearing instance in Power BI Desktop navigator panel, then post the code in the advanced Editor here.

    Regards,
    Lydia

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous,

    Please connect to the table in the appeared instance(poly), then go to Advanced Editor of the imported query in Power BI Desktop query editor, change the instance name in the source code to missing instance name, and check if you get any data. 

    The source code should look like the following:

    let
        Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),
        #"organisation name" = Source{[Name="organisation name"]}[Data],
        servername = #"organisation name"{[Id="servername"]}[Data],
        #"Added Items" = Cube.Transform(servername,
            {
                {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Year", "Month", "Day"}},
                {Cube.AddAndExpandDimensionColumn, "browsertype", {"browsertype"}, {"Browser Type"}},
                {Cube.AddAndExpandDimensionColumn, "mobiledevicetype", {"mobiledevicetype"}, {"Device Type"}},
                {Cube.AddAndExpandDimensionColumn, "page", {"page"}, {"Page"}},
                {Cube.AddMeasureColumn, "Bounces", "bounces"},
                {Cube.AddMeasureColumn, "Entries", "entries"},
                {Cube.AddMeasureColumn, "Unique Visitors", "uniquevisitors"},
                {Cube.AddMeasureColumn, "Visits", "visits"},
                {Cube.ApplyParameter, "DateRange", {#date(2018, 8, 1), #date(2018, 8, 4)}},
                {Cube.ApplyParameter, "Segment", {{"segment_id"}}}
            })
    in
        #"Added Items"


    There is a similar thread for your reference.
    https://community.powerbi.com/t5/Desktop/Data-issue-with-Adobe-Analytics-as-data-source/td-p/483696

    Regards,
    Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thank you Lydia. I am still not clear on how to look for the missing instance. I know the missing instance name is "polypdid". For my other colleagues it does show up in their Power BI desktop navigator panel.

      Can you tell me how will incorporate the polypdid in the code? Thank you so much.

      • Anonymous's avatar
        Anonymous
        Not applicable

        Anonymous,

        Have you checked that if there are any difference between your permission and your colleagues's permission in Adobe Analytics?

        You can firstly connect to the appearing instance in Power BI Desktop navigator panel, then post the code in the advanced Editor here.

        Regards,
        Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi,  any update on this?


    I have the same issue.

     

    Thanks

    Roberto