Thanks for looking at this and replying. This dataset is promoted as a shared dataset to our internal analyst community and we're a Premium subscriber.
Answers to Questions
- The rows are also missing from within the visualization(s).
- If I import the example I provided through the use of Excel, the scenario does not exist and the rows are aggreagted based on one or the other, upper or lowercase, dimensions.
- All of the data content is pulled in from an underlying Snowflake DB
- We're utilizing the Power BI prebuilt Snowflake API connector (straight extracts with no embedded scripts)
- PBI Desktop Version: 2.100.1401.0 64-bit (December 2021)
Storage Modes
- Attribute 1 = Dual
- Attribute 2 = Dual
- Attribute 3 = Direct Query
- Attribute 4 = Direct Query
- Attribute 5 = Direct Query
We have numerous data feeds that flow into our source DB. With this being the case, I don't believe that setting an indexed column would be efficient or even possible. This would have to be put in place for tons of fields. Also, this scenario of upper vs lowercase could flow in at any time for any given text field.
I have verified that the total amount and / or counts is displayed correctly within the visualization. However, the visualization and export utility are not displaying all rows and the sum of these does not equal the visualization totals.
Please let me know if there's anything else I can provide or assist with in regards to this issue.