Dates in visualization go BLANK after refreshing the report in Power BI service

[ERD]

Hello!

I have a table visual with dates columns that work fine in Desktop mode, but appear blank after refreshing the dataset in the PBI Service. It worked at one point in time but not now.  

If I republish the dataset and refresh the report imidiatelly, the report will show the data.

When the refresh of the dataset in PBI Service is finished, the dates dissapear:

No filters are used on this visual or on the page level.

Some details:

• data origin: MS SQL query
• the problem is only with the single table, Date table and some other tables with dates are not affected
• PBI Gateway is used as the data is taken from SQL on-prem server
• column data types in SQL: 

Please, advise what could be the reason of the issue. 

Thank you

[Anonymous]

Hi @ERD 

Please check the date , when refresh in Power BI Service they invert day and month, the day shows as month and the month as day.

The solution goes to change the type of the columm in the query editor, changing the columm type from text to date.

Best Regards,
Community Support Team _ Ailsa Tao

[ERD]

@Anonymous 

The solution goes to change the type of the columm in the query editor, changing the columm type from text to date.

The column type was and is of type Date, not text:

Regards.

[Anonymous]

Hi @ERD 

So have you compared this single table with other normal tables, the difference of the date column ? 

Best Regards,
Community Support Team _ Ailsa Tao

[ERD]

Hello @Anonymous ,

the only difference is the data type in SQL: it's date, while usually datetime.

Thank you