Excel中Power Query转换为仅日期后无数据显示问题求助

I’ve run into exactly this issue before! When converting a Date/Time/Timezone column like Begindatum to a plain date, the query editor might show everything fine, but the data vanishes on Close & Load because of hidden timezone metadata conflicts. Here are the most reliable fixes:

• Replace the transform with a formula to strip timezone completely
  Instead of using the built-in "Transform to Date" option, add a custom column with this formula:

  Date.From([Begindatum])
  

  This explicitly extracts just the date component without leaving any residual timezone data that might break the load process. After creating the custom column, delete the original Begindatum column and rename the new one to match before loading.

• Align timezones first before converting
  If the OData source uses a different timezone than your local Excel environment, mismatches can cause silent load failures. First convert the column to your local timezone, then extract the date:

  Date.From(DateTimeZone.ToLocal([Begindatum]))
  

  This ensures all datetime values are normalized to your system's timezone before stripping the time component.

• Check for hidden load errors
  Sometimes the failure is due to a single problematic row. To see the exact error:

  1. Go to the Data tab in Excel
  2. Open the Queries & Connections pane
  3. Right-click your query and select Load To... to reload, or check the Errors tab for detailed messages
     You can also test with a small subset of data (use Keep Rows > Keep Top Rows in the query editor) to confirm if the issue is with specific rows or the entire dataset.

内容的提问来源于stack exchange，提问作者Stephan