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?
I'm seeing something similar. It seems like some of my measure don't calculate anymore. The really odd thing is that when I get data from a Power BI dataset, I see a similar thing, even when the same measure shows up in the online version of the report. I believe this is a new bug.
I found my issue, it was in the operator error section of errors.
Hello Mdmoo, can you describe in more details what you did to fix it.
This is a big issue to me, and if you can help me I will be very grateful.
Thanks
- Hi there
Thanks for letting us know.
I was fairly certain it could have been something that changed in your data.
I would suggest refreshing the data in Power BI Desktop and checking to see if there are any errors on refreshing?
