Forum Discussion

hi_world's avatar
hi_world
Helper III
3 years ago

numeric type and direct query mode

Hello, 

I'm using direct query mode. 

I have a field as numeric, then power bi sums a it automatically.
when I removed the grouping. I can display the value except that when I scroll down to see all the values, I get an error message.
What is this error message?
How to bypass it?

 

 

Thank you

 

 

 

best regards

 

Need Help
Show and Tell

2 Replies

    • hi_world's avatar
      hi_world
      Helper III
      3 years ago

      amitchandak  that's what's weird because the column is not calculated

       

      in the source à have column1 from table1

      in power bi i have Σ column1 

       

      when i remove Σ    and display column1 in a visual table and scroll down the problem appears.

       

      i have this only with direct query. 
      is this a known problem? how to bypass it ?
      what are the limits of directquery with the use of columns in decimal number ?

      Thank you so much 🙂