Forum Discussion
Wrong date values after publishing report
Memorable MemberHere are a few steps you can try to resolve this issue:
Check Regional Settings: Ensure that the regional settings in both Power BI Desktop and Power BI Service are consistent. Sometimes, discrepancies in date formats can arise from different regional settings.
Data Type Consistency: Verify that the date columns are consistently set to the "Date" data type in both Power BI Desktop and Power BI Service. You mentioned trying this, but double-checking might help.
Power Query Transformations: In Power Query, ensure that any transformations applied to the date columns are correctly set. Sometimes, transformations can cause unexpected changes when the report is published.
Service Settings: Check the settings in the Power BI Service, especially around time zone configurations. Ensure that the time zone settings are consistent with your expectations.
Refresh Schedule: Since you mentioned setting a refresh schedule, ensure that the data source itself is not causing the issue. Sometimes, the data source might have different date formats or time zones that affect the report after refresh.
Browser Cache: Clear your browser cache or try accessing the report from a different browser to see if the issue persists. Sometimes, cached data can cause display issues.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!
Hi, saud968,
Thank you for the reply! I couldn't find "regional settings" in power bi online. I only found settings for the display language, which is the same for power bi service and desktop. The datatype is set to date in Powerbi desktop. But why should be different in power bi service? I uploaded the report from the desktop app and also can't find any option to change the data model in the online service. The behavior is also the same in a different browser.
Hi Numan_Dev ,
You can check if your region settings are consistent by doing the following:
Add the locale in Power BI for Power BI visuals - Power BI | Microsoft Learn
Supported languages and countries/regions for Power BI - Power BI | Microsoft LearnHope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- saud968
Here are a few more detailed steps to help you troubleshoot:
Regional Settings in Power BI Service:
While there isn't a direct "regional settings" option, the language and locale settings can impact date formats. You can check these settings by going to Settings > General > Language in the Power BI Service1.
Verify Locale in Power Query:In Power BI Desktop, open your report and go to Transform Data to open Power Query Editor.
Select the date columns and ensure that the locale is set correctly. You can do this by right-clicking the column, selecting Change Type > Using Locale, and then choosing the appropriate locale (e.g., German - Germany).
Check Browser Locale:Ensure that your browser's locale settings match your desired date format. Sometimes, the browser's locale can override Power BI settings. You can usually find this in your browser's settings under language or content settings.
Data Source Time Zone:Verify that the data source itself is not causing the issue. If the data source has a different time zone or date format, it might affect how dates are displayed after refresh.
Power BI Service Time Zone:In the Power BI Service, check the time zone settings for your workspace. Go to Settings > Datasets > Scheduled Refresh and ensure the time zone is set correctly.
Re-Publish with Clear Cache:Before re-publishing, clear the cache in Power BI Desktop by going to File > Options and settings > Options > Data Load and clearing the cache.
Re-publish the report and see if the issue persists.
Best Regards
Saud Ansari
If this post helps, please Accept it as a Solution to help other members find it. I appreciate your Kudos!Hi, I checked all of these settings before but rechecked them. Everything is set to German. Also, I don't have a problem with the format but with the date values that change when I upload the report.