Direct Query count showing wrong when compare with Import mode in the Table visual

[harib]

Hi All,

I have data with 14976 rows with 100 columns. Total Count values showing correct with Table visual when i use Import mode.

Same Table visual if i use in direct query mode count is showing wrong. In Query mode i can able to see all the data, but in visual count is showing worng.

Attached acreen shots.  I have not used any filters in the report.FYI. 

Can anyone please let us know the issue.

Thanks

[Anonymous]

Facing a similar issue with the Data source as Kusto. Were you able to get through this problem?

[v-shex-msft]

Hi @harib ,

Are you work with original table fields with 'summary' mode or work with calculating fields?
If you mean table columns, please right click on that column to confirm it has summary with 'count' mode instead of 'distinct count' mode.
If you are working with calculating fields, please share the DAX expression for further test.

Regards,

Xiaoxin Sheng

[harib]

@v-shex-msft 

Hi

I have not used any calculated fileds.It's just normal detailed table with few numaric colums. When i use those numaric columns in the table making sum in the propeties.  I don't know why values are showing wrong. 

Onemore thing is there any limitation for columns in direct query. In fact my dataset having nearly 150 columns, those i would like to displayin the table visual.  Any limitation only 100 columns to display in visuals.

Our database is Oracle 12C. FYI

[v-shex-msft]

HI @harib ,

What version of Oracle client are you used? Have you used the corresponding bit version? It may cause the diff between the two modes.
In addition, you can also try to use oracle tools or t-sql to query current data table records to compare with visual data to confirm if this issue is caused by data loading or power bi data analysis.

Regards,

Xiaoxin Sheng