Forum Discussion

SravanKumarg01's avatar
SravanKumarg01
New Member
2 years ago

Date mismatch

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 

Interesting Links

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.           

  • AbhinavJoshi's avatar
    AbhinavJoshi
    Responsive Resident
    2 years ago

    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