cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

ERD_0-1652973973168.png

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

ERD_1-1652974012381.png

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: 

ERD_2-1652974214690.png

 

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

Thank you

 

Status: Investigating

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

Comments
Ailsa-msft
Community Support
Status changed to: Investigating

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
Memorable Member
Memorable Member

@Ailsa-msft 

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:

ERD_0-1653051746946.png

ERD_1-1653051795963.png

Regards.

 

 

Ailsa-msft
Community Support

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
Memorable Member
Memorable Member

Hello @Ailsa-msft ,

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

Thank you