Date Filter Gone Blank After Data Refresh

[Reshaud]

My date filter has gone blank after the dataset refreshes in the power bi portal, after adding the date field to a table i noticed that the year on all dates have changed to 1900. In the power bi desktop version my filter works fine and the year in all the dates are correct even after refreshing. Any ideas on what could have gone wrong with the data on the portal after refresh?

[v-qiuyu-msft]

Hi @Reshaud, 

Which data source does the report get data from? Please republish the report to Power BI service, refresh the dataset again to see if the same issue occurs. 

Best Regards,
Qiuyun Yu

[Reshaud]

Hi @v-qiuyu-msft,

The report gets data from an SQL Server database, after republishing the report and refreshing the dataset the issue occurs again, however, it should be noted that the report appeared to be okay until the dataset refreshed

Regards,

Reshaud Ally

[v-qiuyu-msft]

Hi @Reshaud, 

I'm not able to reproduce the issue on my side. Please update your gateway to the latest version then test again. If the issue still occurs, I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu

[Reshaud]

Hi @v-qiuyu-msft ,

Ended up doing a direct query which resolved my issue

Regards,

Reshaud Ally