Forum Discussion
KPI Preview Feature - SSAS Tabular
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 After enabling the KPI preview freature. Have you tired taking the Status value and using it in a matix or card visual?
Thanks for the quick reply.
I did try. Attached is a screenshot. The PowerBI desktop was restarted after enabling the preview feature. The status shows just values -1, 0 and 1 for the 3 KPI states.
PS: Just adding the part of the script that adds the 3 measures. May be I have added them incorrectly?
#"Added Items" = Cube.Transform(MyCube, {{Cube.AddAndExpandDimensionColumn,
.....
{Cube.AddMeasureColumn, "Value", "[Measures].[MarginKPI]"},
{Cube.AddMeasureColumn, "Goal", "[Measures].[_MarginKPI Goal]"},
{Cube.AddMeasureColumn, "Status", "[Measures].[_MarginKPI Status]"}}
)
I initially had issues getting a KPI to work via a power Pivot model. My issue was that PBI was not recognizing my field as a true KPI. I had to add a power view sheet to my excel file using the kpi value and that somehow fourced PBI desktop to recognize the KPI. The point i'm trying to make is if you are somehow using code or a qiuery to bring in these columns then they might not be recognized as a KPI column. Can you try using a direct connection to the cube and see if that works?
Well.. :smileyhappy: - I managed to make it work
The steps are the following:
- have a tabular SSAS
- create an Excel data model and define the KPIs in the Excel data model
- create a PowerView with those KPIs
- import the Excel workbook into PowerBI desktop
- publish it to the service
- schedule the refresh of the report
As a result I have:
- a report with a matrix with my KPIs indicators;
- I can modify the matrix in the PowerBI desktop however the KPI measures are not displayed as indicators outside the matrix defined in the PowerView
- the KPI indicators are visualized correctly in the service, but the mobile apps present them as a value (-1, 0, 1)
I could not find a way the KPIs from the tabular to be presented in the PowerView->PowerBI. I had to redefine them in the Excel model.
If this is the only way for having KPIs, my opinion is that this is too clumsy and with very limited functionality. Hope this to be changed soon.
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.
That's really good news. Thanks for sharing it. Looking forward the November update :-)
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
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,
