Forum Discussion

Del235's avatar
Del235
Helper III
3 years ago

Count not calculating correctly

I am trying to count text in a column but I'm getting incorrect values.  Example:  I have two columns    Visit Date Attendance Promoter-Detractor 7/9/2023 0:00 Promoter 7/9/2023 0:00 Pr...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Right... a couple of things here. It does sound like either formula will work. If the data you are exporting to Excel via a visual is over a certain number of rows, that is why. Power BI has a row limit for exporting. There are ways around this. I use a combination of Azure data studio and Excel to get mass amounts of data from Power BI. Raw data wise, you can try copying the loaded table from the Table view mode of Power BI (right click table name, copy) and paste it into Excel. This can be quite taxing depending on the amount of data, however. 

Del235's avatar
Del235
Helper III
3 years ago

Its only 2400 rows

 

  • Del235's avatar
    Del235
    Helper III
    3 years ago

    If I open the table in Power Query I see all 2400 rows...

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    If you're in Power Query that's just a preview of the data. Load it into your model and look at the table of data in the Table view mode in model view.