Forum Discussion
Date issue after incremental refresh
Hi kdrees21 ,
It may be because the default date format on the browser is not the date format of the native host and is not recognized, you can try the following:
Go to Setting in power bi service.
Select Language and check if your language setting is on "Default (browser language)"
Let's go to the browser to manage the date format, such as Chrome:
Enter Setting in the browser:
Click its language – Move to the top
Refresh your browser, then go back to the Power BI service opened in Chrome and refresh the page
Refer to：
https://nform.com.au/how-to-change-the-date-format-in-the-power-bi-service/
https://community.powerbi.com/t5/Desktop/Date-format-changing-desktop-to-web/td-p/117204
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi kdrees21 ,
Whether the data that appears in that row is the original header, resulting in the entire date column being formatted incorrectly, or the format of the newly added row is in question.
You can find it in Power Query – Home -- Use First Row as Headers.
The data of the first row is displayed as a header and the rest of the data continues to be displayed in date format.
Or check your regional settings in Power BI. File -> Options and Settings - >Options -> Regional Settings.
Refer to:
Solved: Date Columns recognized as Text not "Date" - Microsoft Power BI Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the response, but this is not the issue. In power bi desktop the formatting is correct and there are no issues. the issue is when I refresh in power bi service my date format does not seem to be recognized.
So before I refresh the published report looks like this with a simlpe count formula:
and after I refresh in the service it turns into this: