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.
Please, advise what could be the reason of the issue.
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
The column type was and is of type Date, not text:
So have you compared this single table with other normal tables, the difference of the date column ?
Hello @Ailsa-msft ,
the only difference is the data type in SQL: it's date, while usually datetime.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.