Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Importing KPI's from SSAS Multi-Dimensional not coming over correctly

I have a couple of KPIs set up within my SSAS cube.  If I connect live to the cube, they come up perfectly in power BI (red dot, green dot, yellow dot, etc.)  When I import them, the status comes over as the -1, 1, etc.  I also don't get the little traffic light beside them to indicate they are KPIs.  It is treating them as values.  Any ideas how to fix this when importing?

Need Help

1 Reply

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Anonymous

     

    In Power BI Desktop, when using importing mode, it just retrieves raw data from data source and generate a dataset, so each object will be resolved as data fields. To use the source schema of SSAS cube, you have to use live connection. Then those Analysis Services objects (like measures, dimensions, hierarchies, KPIs) will be fully imported. Please also refer to a similar thread below:

     

    http://community.powerbi.com/t5/Desktop/How-to-use-SSAS-MD-KPIs/m-p/18325#

     

    Regards,