Remove Value Attribute from Power BI

Author: Kepion Product Team

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. Check the Exclude Default Value Column checkbox.

4. Save and Deploy the application to OLAP.

5. Refresh your Power BI connection. The value attributes should be removed.