Forum Discussion

harib's avatar
harib
Post Patron
6 years ago

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

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 sho...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    harib
    Post Patron
    6 years ago

    Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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