PowerPivot KPIs

[Tsanka]

Hi guys,

It seems that the PowerPivot KPIs are not supported in the PowerBI designer/desktop. When an Excel file with KPIs is uploaded in PowerBI, it is well visualized in PowerBI mobile, however it cannot be edited/seen in the designer ("Visual type is not yet supported"). Do you plan to add them soon?

The new PowerBI has really cool new features however we would prefer to work with the Excel PowerPivots as the reports built in Excel support table row KPIs and have drill-down functionality.

Thanks

Tsanka

[cwebb22]

This is now supported (in preview). Learn more here: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-import-and-display-kpis/

See it in action here: http://community.powerbi.com/t5/Data-Stories-Gallery/Gartner-Critical-Capabilities-for-Business-Inte...

🙂

[Anonymous]

Additionally there is no Idea also to support this,

Let’s add here https://support.powerbi.com/forums/265200-power-bi

And vote! 

[Tsanka]

Thanks for the idea.

I found this thread https://support.powerbi.com/forums/265200-power-bi/suggestions/8276622-create-kpi-in-designer-file and will vote there hoping to be heard.

[diverdown1964 · Accepted solution]

You can connect to Excel instead of importing it. WHen you do that, you can render the workbook in full fidelity including your KPIs.

[Akahn]

What if you build the entire thing in PowerBI Desktop? What if there is no PowerPivot model. What then?

[anywhereanytime]

It's now September 7, 2015 - happy Labor Day in the US - is there any update on KPIs in the new Power BI 2.0 either by "pinning" to a dashboard or natively in the Power BI desktop?

[Tsanka]

Thanks for the input.

I tried the proposed approach - got data from a connected Excel file with PowerPivots and KPIs there. When I try to view/edit the file from PowerBI, the file is opened in Excel Online and there KPIs are rendered. This however is not what I would like to achieve - to be able to use the new visuals in PowerBI together with the KPIs from the Excel PowerPivots.

[andre]

The service does not yet render Excel in high fidelity for me as well. However, Microsoft did go on record that this feature is coming and at some point we will be able to pin Excel charts to dashboards the same way we can Power View charts. (Although I don’t know if Desktop/Service charts can still be technically called Power View or whether there is a new name for this visualization technology)

[crmguru]

Today is now September 20, 2015 - almost 2 moths after launch - any updates to both full fidelity rendering of Excel and KPIs?