Forum Discussion
Wrong date values after publishing report
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.
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!
- Numan_Dev1 year agoFrequent Visitor
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.