Forum Discussion
guibenassi
7 years agoAdvocate II
Power BI Service - Data Missing after refresh
I have some files that works fine in Power BI desktop, but after upload and refresh the files on service power BI some data doesn´t shows any more. I try to delete some measures and some case it wor...
- 7 years ago
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
7 years agoSuper User
Hi there
When you are in the report in the Power BI Service, do you have the default filters set or persistent filters?
I have never seen data refreshing if it was the same in Power BI Desktop.
What I have seen is filters or slicers being applied to the reports, which makes it appear that there is data missing.
When you are in the report in the Power BI Service, do you have the default filters set or persistent filters?
I have never seen data refreshing if it was the same in Power BI Desktop.
What I have seen is filters or slicers being applied to the reports, which makes it appear that there is data missing.
guibenassi
7 years agoAdvocate II
Hello Gilbert,
I just update and refresh the report in service power BI, I don´t use any filter at all.