Date/Time/Timezone Column is blank when refreshed in PowerBi Service

When you set up your connection 

Here, click on advanced Options, then you have to write the query,

If you know the name of the table, you can make something simple like:

Select *,
CAST(TRANSACTION_TIME AS TIMESTAMP_NTZ) AS Transaction_Time_Clean
FROM TABLENAME

Replace TRANSACTION_TIME  by the name of the column you are facing the issue with the date

HI wiselyman3 ,

Thank you for reaching out to the Microsoft Community Forum.

Please check below things to fix the issue.

1. Ensure that the role used in Power BI Service is explicitly defined and has access to the Date/Time/Timezone column. Avoid relying on default roles, especially if using SSO or On-Premises Gateway.

2. If you are using DateTime.LocalNow(), consider replacing them with static values or parameters passed from the source system. Alternatively, use a custom function that adjusts for UTC and daylight saving time.

3. Ensure that the Date/Time/Timezone column is not being implicitly converted to a type that Power BI Service cannot interpret. If you changed it to Text, make sure the transformation is applied consistently across all steps and that the column is not being dropped or overwritten during refresh.

4. If you are using an On-Premises Data Gateway, ensure it’s configured with the correct Snowflake role and that the gateway version supports the features you need AAD SSO.

5. Power BI Desktop may be using your machine locale, while the Service uses the default locale of your tenant. Normalize Formats in Power Query.

Please refer Microsoft article and community threads.

Auto date/time in Power BI Desktop - Power BI | Microsoft Learn

Solved: Time columns blank / empty after publish / refresh - Microsoft Fabric Community

Solved: Re: PBI Service refresh empty columns - Microsoft Fabric Community

Solved: blank dates causing issues in Power BI service - Microsoft Fabric Community

Solved: Blank dates in PowerBI report - Microsoft Fabric Community

Solved: Missing column when refreshing - Microsoft Fabric Community

Solved: DateTimeZone not recognized when using DateTimeZon... - Microsoft Fabric Community

Solved: Today's date not refreshing in Power Bi Service - Microsoft Fabric Community

If my response has resolved your query, please mark it as the "Accepted Solution" to assist others. Additionally, a "Kudos" would be appreciated if you found my response helpful.

Thank you