Forum Discussion
Count not calculating correctly
So...
We store data on Snowflake. I am connecting Power BI to Snowflake and use DirectQuery to connect to it. Today I downloaded the data from snowflake and opened in Excel. It ma
tches the totals I get in Power BI. BUT... The example I used was from a table I created in PBI using all of the columns with no filters. That was the example I used above. Turns out the Original formula I used was correct because it is seeing all of the data. The export of the table is missing data but there are no filters (I Swear). So there isn't a formula problem but why isn't all of the data appearing.
See the data below:
| Snowflake | PBI-Export | |||
| Date | Promoter-Detractor | Date | Promoter-Detractor | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Detractor | |
| 7/9/2023 | Neutral | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Neutral | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | 7/9/2023 | Promoter | |
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Neutral | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Detractor | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter | |||
| 7/9/2023 | Promoter |
| ||
|
There are no filters but I can't figure out why the other rows don't appear but the formula counting the rows sees them and counts them.
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.
Its only 2400 rows
If I open the table in Power Query I see all 2400 rows...
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.