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,

atul_kushwaha's avatar
atul_kushwaha
Frequent Visitor
10 years ago

I think this issue still there even after Nov'15 Update. I have defined KPI in SSAS Tabular Model and connected it as LIVE SOURCE in PBI Desktop but only Measure is being shown, NO Status & Goal measures shown.

 

Whereas I can see KPI Measure Group in Excel when connect to same Tabular Model.

 

Regards,

Atul Kushwaha

atul_kushwaha's avatar
atul_kushwaha
Frequent Visitor
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

    Hi atul_kushwaha,

     

    Could you pease describe the steps that you have done to achive the goal? My cube has compatibility level 1103 (seen on database level and as a property in the VS) and still I am not able to see the KPIs. Obviously I am missing something.

     

    If possible, could you pease also paste the defintion of one of your KPIs (the XML element as seen in the XMLA definition of the cube).

     

    Thanks

    Tsanka

     

    • atul_kushwaha's avatar
      atul_kushwaha
      Frequent Visitor
      10 years ago

      Tsanka Just change Compatability Level to - SQL Server 2014 / SQL Server 2012 SP1 (1103).  

      • 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