Forum Discussion

tomasmartinek's avatar
tomasmartinek
Frequent Visitor
5 years ago
Solved

Adobe Connector and date range parameter

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), #d...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi tomasmartinek ,

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

     

  • Anonymous's avatar
    Anonymous
    5 years ago

    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.

ReportMaster's avatar
ReportMaster
Post Partisan
2 years ago

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