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

mdmoo's avatar
mdmoo
Frequent Visitor
7 years ago

I found my issue, it was in the operator error section of errors.

guibenassi's avatar
guibenassi
Advocate II
7 years ago

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

 

  • GilbertQ's avatar
    GilbertQ
    Super User
    7 years ago
    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?