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
mdmoo Can you elaborate more on your issue and solution please?
GilbertQ That's the strange part, when I refresh my date in Power BI desktop, it just works perfectly fine also when publishing in web service. However, when automated refresh is done in web service, only two graphs (with calculation) of 27 are turning blank (deleted values/blank values). It looks like de calculated columns in these two graphs won't work in web service, noticing that it worked perfectly fine before.
Is there any reaction on the ticket to Microsoft?
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
