Introduction
When connecting to Kepion cubes from Power BI, you may notice attributes ending with value. Some of the value attributes are necessary, as they may relate to the Time Dimension. However, for most Dimensions, the value attributes are likely extraneous.
In this article, we'll show you how to remove the extraneous values by using the Exclude Default Value Column option.
Solution
1. Go to the Modeler.
2. Under Application, select Settings.
3. Select the Exclude Default Value Column checkbox to enable.
4. Save and Deploy.
5. Refresh your Power BI connection. The value attributes should be removed.