Forum Discussion
Power BI Service - Data Missing after refresh
Microsoft answer the ticket with a solution.
The problem is caused by a date issue, 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.
In the begining I change the type direct in the table section, when refresh by power BI service it get the data from the query wich is in text format and bringing problems with English an EU date system.
Hope I help you guys.
Thanks for the support
GilbertQ Anonymous describe exactly what happens, some reports works fine, others don´t and there are no problems in Power BI Desktop or even in uploading, the error appears only after refresh the service.
I am expecting a call from the ticket today, hopefuly we will have good news.
Microsoft answer the ticket with a solution.
The problem is caused by a date issue, 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.
In the begining I change the type direct in the table section, when refresh by power BI service it get the data from the query wich is in text format and bringing problems with English an EU date system.
Hope I help you guys.
Thanks for the support
- That is great to know and I would recommend best practise is always to set your column data types to ensure that they are in the valid format.
i changed my date/time format to date only format in the query editor , my report is now viewable. thank you.
Excellent solution
