Date mismatch

[SravanKumarg01]

Hi i have uploaded data using parameter query into Power BI when I tried to validate the values with azure databricks it is matching with 1 day less date how to rectify the issue it should be same date with azure databricks and power BI 

[AbhinavJoshi]

Hello @SravanKumarg01. If the suggestions provided by @Anonymous doesn't work for you, I'd recommend checking for any Power Query Transformations that might occur before loading the data. Or, if you are constantly getting one day less, you can modify your M code to match what is in databricks. Thanks

[Anonymous]

Hi @SravanKumarg01 ,

I understand that you are facing an issue with the date validation of your data in Power BI and Azure Databricks. Please try the following steps to resolve the issue:

1.Ensure that the date format in your data source is consistent with the date format in Power BI and Azure Databricks.

2.Check if there is any time zone difference between your data source and Power BI or Azure Databricks.

3.Verify that you are using the latest version of Power BI Desktop (2.85.681.0 or above) and Azure Databricks.

Best Regards,

Stephen Tao

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