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 d...
Need Help
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

  • chocomart's avatar
    chocomart
    Helper I
    6 years ago

    Hi Xiaoxin,

     

    I can confirm that the data exists in my table, here are some odbc drivers that we use. still cannot find the data when all the tables are loaded in the report

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi chocomart,

      So you mean these data are from a SQL database? If you use a normal SQL connector, can you get full records to power bi desktop side?

      If this is a case, I'd like to suggest you check your credentials(both two credentials that your use on the database and power bi desktop connector) and security settings to confirm if any security filter applies on your records that causing the missing.

      Regards,

      Xiaoxin Sheng