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. We can solve this using the Exclude Default Value Column option.

Solution

To remove the value attributes, go into the MODELER and check the Exclude Default Value Column checkbox. Save and deploy the application to OLAP.

Refresh your Power BI connection, and the value attributes should be removed.