Power BI report is showing Incorrect Data in Service.

[Siddhesh_Pal]

Hi Community,

I am publishing the report from Power BI Desktop, the date having the following year 

After publishing the report, Date Year is starting from 1899 

When i published the report it show the proper date in the service after refreshing the service browser its get changed and it shows the Date Year from 1899.

Please suggest reason why Date Year is starting from 1899.

[AnalyticsWizard · Accepted solution]

hi @Siddhesh_Pal 

There are few possible reasons and solutions for this behavior:

1. Date Data Type:

   • First, ensure that the column containing the date values in your data source is correctly recognized as a date data type. If it’s not, Power BI might interpret it incorrectly.
   • In Power Query, verify that the data type for your date column is set to Date.

2. Date Format in Power Query:

   • Check the date format in Power Query (Power Query Editor) to ensure it matches the expected format.
   • Sometimes, incorrect date formats can lead to unexpected results. Make sure the date values are consistent and correctly formatted.

3. Date Values Prior to 1900:

   • Power BI uses a base date of December 30, 1899 (represented as 0) for date calculations. Any date prior to this will result in negative values.
   • If your data contains dates before 1900, they might be causing the unexpected behavior. Ensure that your data doesn’t include dates earlier than 1899.

4. Date Transformation in Power Query:

   • If you’re performing any date transformations (e.g., adding or subtracting days), double-check those steps in Power Query.
   • Incorrect transformations can lead to unexpected results.

5. Date Display Format in Report Visuals:

   • After publishing the report, check the date display format in your visuals (tables, charts, etc.).
   • Right-click on the date column in the visual and select Format. Ensure that the format is set to the desired date format (e.g., “MM/dd/yyyy”).

6. Date Format in Power BI Service:

   • When you publish the report to the Power BI service, verify the date format there as well.
   • Sometimes, the default date format in the service might differ from what you see in Power BI Desktop.

7. Date Hierarchy:

   • If you’re using a date hierarchy (e.g., Year, Quarter, Month), ensure that it’s set up correctly.
   • Check if the hierarchy is causing unexpected behavior.

8. Data Refresh Behavior:

   • The issue you described occurs after refreshing the service browser. Confirm that the data refresh process isn’t altering the date values.

9. Test with a Simple Date Column:

   • Create a simple test report with just a date column (without any complex transformations) and publish it.
   • Observe if the issue persists. This will help isolate the problem.

10. Contact Power BI Support:

    • If none of the above solutions resolve the issue, consider reaching out to Power BI support for further assistance.