Adobe Analytics Power BI Connector Issue | Community
Skip to main content
TimoSt1
New Participant
Feb 13, 2024 12:59 PM UTC
Solved

Adobe Analytics Power BI Connector Issue

Hi,

Currently, I try the first time the possbilities of Adobe Analytics Data in PowerBi. But if I try to connect Adobe Analytics with PowerBi via the connector I get always the following message "Expression.Error: Start and end parameters must be of type Date or Datetime.". What I have to change in PowerBi, do you know?

Kind regards,

Timo

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Jennifer_Dungan
Jennifer_DunganAccepted solution
Level 2
Feb 22, 2024 2:06 PM UTC

Yeah, I figured... it's just that the error seems to be around the dates provided "not being in date format".

 

What about the Date Format in Adobe? Maybe the error is coming from from there? And you have to match whatever date format is set up in your Adobe, rather than the date format in PBI?

 

The error message isn't very helpful right now in explaining why it thinks the dates aren't in date format, or what format it expects....

View reply

4 replies

PrassanaBa
New Participant
Jul 31, 2024 6:52 PM UTC

Is there a way to set the date range from a static date to current date?

For an example; start date 3/13/2024 to today. 
If I automate it I need to pull data up to today going forward.

Translate
Jennifer_Dungan
Jennifer_Dungan
Level 2
Feb 13, 2024 9:12 PM UTC

I don't us Power BI, but could the issue be the formatting of your dates?

 

Have you tried MM/DD/YYYY format?

 

DD.MM.YYYY isn't really a "standard" date format that I've seen.. unless you've changed the settings in Power BI, it's possible that it just doesn't understand that format? It may even be that custom date settings in Power BI don't work in that interface?

 

 

 

Translate
TimoSt1Author
New Participant
Feb 22, 2024 1:08 PM UTC

Hi Jennifer,

First of all, thank you for your answer.

Unfortunately, the date format is not the reason for. The selected format is local setting (in my case German) of PBI. But, if I set that to another format (e.g. Englisch US) it don't fix it and the message is still the same.

KR,

Timo

Translate
    Jennifer_Dungan
    Jennifer_DunganAccepted solution
    Level 2
    Feb 22, 2024 2:06 PM UTC

    Yeah, I figured... it's just that the error seems to be around the dates provided "not being in date format".

     

    What about the Date Format in Adobe? Maybe the error is coming from from there? And you have to match whatever date format is set up in your Adobe, rather than the date format in PBI?

     

    The error message isn't very helpful right now in explaining why it thinks the dates aren't in date format, or what format it expects....

    Translate
    Terms & ConditionsAccessibility statement

    Loading footer...