Forum Discussion
Kudo CollectorPowerPivot KPIs
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
You can connect to Excel instead of importing it. WHen you do that, you can render the workbook in full fidelity including your KPIs.
9 Replies
- diverdown1964
Most Valuable Professional
You can connect to Excel instead of importing it. WHen you do that, you can render the workbook in full fidelity including your KPIs.
TsankaThanks 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
Memorable Member
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)
- Akahn
Advocate IV
What if you build the entire thing in PowerBI Desktop? What if there is no PowerPivot model. What then?
anywhereanytimeHelper III
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?
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.
- cwebb22
Advocate II
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-Intelligence-and/m-p/139211#M712
:)
