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...
  • 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

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