Forum Discussion

guibenassi's avatar
guibenassi
Advocate II
7 years ago
Solved

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...
Need Help
  • guibenassi's avatar
    guibenassi
    7 years ago

    Anonymous mdmoo GilbertQ 

    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

jakemorris606's avatar
jakemorris606
Frequent Visitor
4 years ago

Hello,

 

not sure if anyone is stilll having simular issue, i had this issue for a couple of days ... for me i had the incremental refresh data starting '1' month before data on the table, so in desktop my dataset was full, but once i published to service and it refresh it would only pull in 1 month of data resulting in missing data, so if anyone has this issue going forward this i one to check.      service will use parameters set in desktop.