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
I'm having the same problem, since last week :/ Report has been working perfectly for weeks and now suddenly deletes data after refresh.
Im saying 'deletes, because I've found out that after updating the file, the data is shown again in the graph. However, after refreshing, the data is just missing. After downloading the file from PBI service, I see that the columns with data are blank (have been deleted).
My data set contains data with thousands with decimal number in dutch format (so with comma instead of dot) and is calculated dividing price (decimal) by total. Maybe it has to do with this, not sure?
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.
- It could possibly be a bug, but I have never seen the Power BI Service delete any data.
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?
