Forum Discussion
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...
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
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