Adobe Connector and date range parameter

[tomasmartinek]

Hello,

I am trying to change date to relative in adobe analytics connector from "anything" (last 60 days or from 1/1/2021) to today.

{Cube.ApplyParameter, "DateRange", {#date(2021, 7, 13), #date(2021, 7, 13)}},

I tried change date to 2021, 12, 31 - but with errors and tried used LocalNow, but I have errors here

{Cube.ApplyParameter, "DateRange", {#date(2021, 7, 13), #date(DateTime.LocalNow())}},

Is here any solution how to create auto update time in adobe analytics connector?

Thanks

Tomas

Thank

[ImkeF · Accepted solution]

Hi @tomasmartinek ,

use Date.From ( DateTime.LocalNow() ) instead of #date.

[ReportMaster]

Hi @tomasmartinek As a workaround, maybe you can connect your Adobe data using a 3rd party connector. I've tried windsor.ai , supemetrics and funnel.io. I currently use windsor.ai 's Adobe connector and I can filter my data by date range or fields before exporting to PBI. In case you wonder,  to make the connection first search for the Adobe connector in the data sources list:

Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link

[Anonymous · Accepted solution]

@tomasmartinek "
This is because you your first date return Date only, and DateTime.LocalNow() returns Date and Time. Change it to the expression below.

DateTime.Date(DateTime.LocalNow())

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[ImkeF · Accepted solution]

Hi @tomasmartinek ,

use Date.From ( DateTime.LocalNow() ) instead of #date.