Forum Discussion

AlphaBeta's avatar
AlphaBeta
Frequent Visitor
8 years ago
Solved

Adobe Analytics Only 7 Days of Data

Hello,

 

I am trying to develop a set of reports for some of our Ops folks from our Adobe Analytics account.  I have successfully connected the two platforms, however they need a substantial amount of data more than what Power Bi is showing.  I can only get the last 7 days.  Is it possible to get access to the last two years worth of data?

 

Is there some dynamic date range I can push the data with?

 

Thanks in advance.

  • Anonymous's avatar
    Anonymous
    8 years ago

    AlphaBeta,

    Do you directly connect to Adobe Analytics in Power BI Service following the guide in this article? If so, there is no method to change the data range.

    In this case, I would recommend you use Power BI Desktop to connect to Adobe Analytics, then develop your reports. For more details, please review this blog.

    Alternatively, you can connect to Adobe Analytics PBIT in Power BI Desktop.

    Regards,
    Lydia

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    AlphaBeta,

    Do you directly connect to Adobe Analytics in Power BI Service following the guide in this article? If so, there is no method to change the data range.

    In this case, I would recommend you use Power BI Desktop to connect to Adobe Analytics, then develop your reports. For more details, please review this blog.

    Alternatively, you can connect to Adobe Analytics PBIT in Power BI Desktop.

    Regards,
    Lydia

    • AlphaBeta's avatar
      AlphaBeta
      Frequent Visitor
      8 years ago

      Thank you the blog post gave me exactly what I was looking for.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous 

       

      I was very excited to find your link to the Adobe Pbit files as I have been hunting for them for a while. Unfortunately, on accessing the link, I get an error saying the files are no longer available and may have been removed ... Any idea where I can find them?

       

      Thanks and Regards

       

      Doug

  • srinivas258's avatar
    srinivas258
    Icon for Helper I rankHelper I
    6 years ago

    AlphaBeta 

    I am trying to create report using Adobe connector. Basically I would like to know how many page visits are there for a specific page breakdown by date. When I connect to Adobe there is Date Range (optional) under parameters section. How can I make this dynamic to get last 7days metrics whenever the user refresh the report. Can you please suggest if you have done this?

    Thank you. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi

    I got around it by editing in the Advanced Editor, as below, to create a rolling 10 day window

    {Cube.ApplyParameter, "DateRange", {Date.AddDays(Date.From(DateTime.LocalNow()),-10), Date.AddDays(Date.From(DateTime.LocalNow()),-1)}}

    Note: you will lose the ability to use the drop downs and have to revert to the Advanced editor to make changes

    Hope it helps

    Regards

    Doug

    • srinivas258's avatar
      srinivas258
      Icon for Helper I rankHelper I
      6 years ago

      Ji Anonymous 

       

      Thanks for the reply. But looks like DateRange is coming as text by default so the below is not working for me.

       

      Did you convert it to date? Can you please suggest?

       

      {Cube.ApplyParameter, "DateRange", {Date.AddDays(Date.From(DateTime.LocalNow()),-7), Date.AddDays(Date.From(DateTime.LocalNow()),-1)}}

       

      Thank you.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi srinivas258 

         

        Looking at my code I have a DateGranularity line following the DateRange command

         

        Hope you come right

         

        Regards

         

        Doug