Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago
Solved

KPI Preview Feature - SSAS Tabular

Hi   The blog information about the October update of PowerBI desktop states that KPI preview visualization is supported from PowerPivot or SSAS tabular.   I created a simple KPI in my tabular an...
Need Help
  • atul_kushwaha's avatar
    atul_kushwaha
    10 years ago

    I managed to resolve this issue.

     

    Issue was witrh compatability mode of SSAS Tabular Model. I set it to "SQL Server 2014 / SQL Server 2012 SP1 (1103):" and defgined KPI started showing in both Power BI Desktopp & Power view.

     

    Hope it will hep others those may face similar problem.

     

     

    Atul,

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

I managed to find some time to try the KPI functionality and again with no success.

 

I have on-premise tabular cube, its compatibility level is SQL Server 2012 SP1 (1103). There are KPIs defined in the tabular mode.

 

What I tried is the following:

- connect to the cube and select the fact table. Data are imported into my model, including the defined measures. The measure with KPI is imported, but seen as three fields - value, goal and status.

- connect to the cube and import data using a MDX query. The KPIs are again imported as value, goal and status.

 

atul_kushwaha, please advise - how did you manage to have KPIs in your tabular? Again going to Excel? What data type your KPI is in Power Desktop? Thanks