Adobe Analytics Only 7 Days of Data

[AlphaBeta]

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.

[DougM]

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]

Ji @DougM 

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.

[DougM]

Hi @srinivas258 

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

Hope you come right

Regards

Doug

[srinivas258]

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

[v-yuezhe-msft · Accepted solution]

@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

[DougM]

Hi @v-yuezhe-msft 

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

[AlphaBeta]

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