Forum Discussion

Jeremy19's avatar
Jeremy19
Helper III
2 years ago
Solved

Date format error with parameters

Hello all, I want to use incremental refresh but I having a problem filtering my dates. I have an error when filtering my dates. I have created my two date parameters like this :   and I fil...
Need Help
  • Alex87's avatar
    Alex87
    2 years ago

    Bonjour,

    Parfois, des formats mixtes (par exemple, « MM/JJ/AAAA » et « JJ/MM/AAAA ») peuvent entraîner des erreurs d'analyse.

    Vérifiez les paramètres régionaux dans vos données sources et dans Power BI Desktop pour assurer leur compatibilité. Les différences régionales peuvent provoquer des erreurs d'analyse de dates. 

    Lors de la configuration de l'actualisation incrémentielle, assurez-vous d'utiliser des paramètres valides correspondant à la plage de dates prévue. Réglez vos paramètres sur Date/Time si vous souhaitez configurer l'actualisation incrémentielle.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, 

Thanks for the solution Alex87  offered and i want to offer some more infotmation for user to refer to.

hello Jeremy19 , you need to check that in your data, whether your date column is right, make sure that all the data in this column is date format. whether it has the error in this column,if it has the error, it means that the date format is not right. You can refer to the following link.

Solved: DataFormat.Error: We couldn't parse the input prov... - Microsoft Fabric Community

And If you need to use the incremental refresh, you need to the paramater types are both date/time. you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#supported-data-sources

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.