Date data showing as "null" even though source data has values - Date column

Happytravel2025 

Checklist of Common Causes and Fixes

1. Data Format Issue (Power BI treats it as a Record)

SharePoint often stores complex fields like "Date and Time" as a record object instead of a flat value — especially if the column has time or time zone info.

Fix:

• In Power Query, click on the column header showing null values

If it says "Record" in each row, click the expand icon (⤢) next to the column name
→ Then select the field like DateTime or Value
→ You should see the actual dates.

2. API Throttling or Limitations

SharePoint Online can throttle large lists or fields not included in default API calls.

Fix:

• Go to Power Query → Click "Source" step

• Change the SharePoint.Contents method to SharePoint.Tables instead of SharePoint.Contents, if you're manually constructing the M query

Alternatively, use OData feed URL to be more specific about the columns.

3. Versioning or Hidden Data

Sometimes, SharePoint fields are populated after form submission, especially with automated flows or calculated fields.

Fix:

• Ensure the field isn't a calculated column — calculated columns often do not export properly to Power BI

In Power Query, go to Advanced Editor → check the actual column names being loaded

4. Field Not Promoted to View Properly

Even if the field is visible in your view, Power BI sometimes ignores it if it’s not promoted properly in SharePoint schema.

Fix:

• In SharePoint list settings, go to the specific column settings → check if it’s set to show in all content types and views

Also try creating a new view with only that date column and import that view into Power BI

How to Debug in Power BI

1. In Power Query → Step through each step from Source to Navigation

2. Look at the Date column:

   • Does it say "null"? → Try expanding it

   • Does it say "error"? → Click into the error and review the message

3. If the column shows as Record or Error, that’s your clue.
   
   

   Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!