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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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? 

 

 

  • mdmoo's avatar
    mdmoo
    Frequent Visitor
    7 years ago

    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.

    • 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

         

  • guibenassi's avatar
    guibenassi
    Advocate II
    7 years ago

    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.

     

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

        Hello Gilbert.

        For sure it is a good start, I checked the gateway version and desktop version in advance to post this issue.

        Thanks