Power BI service error - Date time format

Hi KM06 ,

Thanks for reaching out to the Microsoft fabric community forum.

GilbertQ ,

Thank you for your prompt response.

In addition to GilbertQ , input, I have added more troubleshooting steps that may help resolve the issue, along with links to previously solved threads with similar issues.

To fix the DateTimeZone parsing error in Power BI Service, start by updating your Power Query transformations to explicitly convert date strings using ISO format like 2025-06-30T00:00:00Z via DateTimeZone.FromText, which eliminates locale ambiguity. Ensure the machine running your on-premises gateway has its regional settings aligned to your expected date format for example, set it to English (United Kingdom) or English (India) via Control Panel → Region → Formats, and restart the gateway after changing. Also, update your gateway to the latest version from Microsoft's official site to avoid known parsing bugs, and consider disabling HTTPS mode in the gateway config tool if issues persist. As a diagnostic aid, wrap your transformation in a try...otherwise clause to catch problematic rows and pinpoint inconsistencies. To confirm the fix, test a dummy table with hardcoded ISO-format dates and verify that it refreshes correctly in the service. This will isolate whether your source data or environment setup is causing the issue.

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out  we’d be more than happy to assist you further.

We look forward to hearing from you.

Best regards,
Lakshmi