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,

meysun's avatar
meysun
Resolver IV
10 years ago

The upcoming November update should fix this. Once it's available ( very soon :), please give it a try and if the issue still repros, let us know.

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).