Forum Discussion

chocomart's avatar
chocomart
Helper I
6 years ago

Some data rows are missing

Good day everyone,

 

Just recently I've noticed that we are missing 2 data row that should be included on the Query result, I've checked and tried removing all filters but still those missing row doesn't show up. When i've tried using the same query directly on our DB the missing rows are there. Any idea if this is a bug or am i missing something?

 

 

see sample screenshot below, one invoice is missing (428708)

 

Need Help

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI chocomart,

    What type of connector are you test? Connection Mode? Any interaction from other visuals to table visual that filter some records?

    Please share more detail information to help us clarify your scenario.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng

    • chocomart's avatar
      chocomart
      Helper I
      6 years ago

      hI Anonymous ,

       

      I'm using ODBC to gather my data from our DB, as i've mentioned previously, i've tested getting rid of all the filters and no other table interacting with it.

       

      I'm doing a union for my Data table 1(which contains old records) and Data Table 2(which contains current records)

       

      weirdly enough see attached pbi file as when i removed all the other tables the data pops up.

       

      https://1drv.ms/u/s!AjpCgUZic0x8mReSnXVEYTd0GthN?e=CLFmss

  • wzkoral's avatar
    wzkoral
    Advocate II
    6 years ago

    1.Try to search not by visualization but with table in power BI Desktop not querry
    2. Check the relation (should be one direction )

    • chocomart's avatar
      chocomart
      Helper I
      6 years ago

      Hi wzkoral ,

       

      Thanks for the help, although i've tried looking for it on the table view as well but it's not there, also the data is coming off just one table so i'm not sure how the relationship could hide those missing rows?

  • wzkoral's avatar
    wzkoral
    Advocate II
    6 years ago

    I have download your test file and the number you missing, i see. So maybe send scren with relation viem between table for better view.
    In this day you have two invoice for one customer and that why i think about wrong relation betwen table, chceck if value is shown with sunarize, or put the Date twice , first dont summarize second as count and look for value more then 1 . 

     



    Ps/ sory for my English

    • chocomart's avatar
      chocomart
      Helper I
      6 years ago

      Its okay, that's the thing, one customer can have multiple invoices in a day. I've found out that when i remove all the other tables in the report that's when it started popping up.

       

      anything that i should look into?

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI chocomart,

        You can try to use the following measure formula to extract missed records and export as CSV format:

        Measure =
VAR original =
    SELECTCOLUMNS (
        VALUES ( 'PIVOT 9 OLD'[INVOICENUMBER] ),
        "Value", VALUE ( [INVOICENUMBER] )
    )
VAR full =
    GENERATESERIES (
        VALUE ( MINX ( original, [Value] ) ),
        VALUE ( MAXX ( original, [Value] ) )
    )
RETURN
    CONCATENATEX ( EXCEPT ( full, original ), [Value], "," )

        After exported records, you can use them in your database to filter records to confirm if they really existed in your table.

        In addition, what version of odbc driver are you test? Have you tried to use other connectors to get data? (driver compatibility issue may also cause the records missing or recognize wrong records)

        Regards,

        Xiaoxin Sheng