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
Hello, I am not sure what cause this issue, but I have a feeling that can be a problem with regional format, im my case I use big volume of data ( 9 Million lines) and use Brazilian format (comma instead of dot).
I open a service call with Microsoft team that is working in that.
I would also double check that the latest version of the Power BI On-Premise Data Gateway is installed?
Hello Gilbert.
For sure it is a good start, I checked the gateway version and desktop version in advance to post this issue.
Thanks
- If that is the case I am not sure what could be causing the issue.
The only other test I could think of before logging a support request is to try and upload the report into a new app workspace, schedule a refresh and see how it refreshes as expected?I have already uploaded in a different workspace, delete the old report but the problems persist.
I have already opened a ticket service in Microsoft, and there are more than 10 days duration and no effective response at all.