Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @tomasmartinek ,
use Date.From ( DateTime.LocalNow() ) instead of #date.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@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.
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
@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.
Hi @tomasmartinek ,
use Date.From ( DateTime.LocalNow() ) instead of #date.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries