Instantly connect Excel to Microsoft Power BI (desktop & online) and Online Analytical Processing (OLAP) data cubes using QuickConnect. All connections are automatically saved, so all you have to do is hit refresh to get everything up to date.
Find exactly what you want regardless of how complex your PivotTables are. PowerBI SmartPivot's search functions instantly scan all data content on your analytical model and allows you to add any values found this way to the location of your choice.
Apply filter values to a report in bulk and stop individually checking each box in the filter pane. Instead, simply paste the entire list of values in the slicer visual to filter by exactly what you wish. You can save the filters you've set in order to use them later.
Create highly detailed and faster table reports from your PivotTables in Excel.
FAQs
PowerBI SmartPivot is an Excel add-in that offers several new features, namely the ability to connect Microsoft Power BI (Desktop and Online) and OLAP data cubes to it, perform granular searches in all data content, filter a PivotTable by a list of pasted or written values (instead of ticking each value) and create granular table reports.
To install and use PowerBI SmartPivot, you only need a valid Microsoft Office 2013, 2016 or Office 365 license.
No, PowerBI SmartPivot isn't currently available for Office for Mac.
The trial version of PowerBI SmartPivot is only valid for 30 days. All features are fully available during the trial period.
Once activated, a PowerBI SmartPivot license is valid for 1 year.
Once you start using PowerBI SmartPivot, all your custom filters are saved in the folder %appdata%\Devscope\PowerBISmartPivot.
Our PowerBI suite offers a range of products that help professionals make the most of business intelligence.
TripleLift is an advertising technology company that has been a pioneer in programmatic advertising - the process of automatically buying and selling digital ad space. Founded in 2012, TripleLift offers the world's leading publishers, brands and agencies an omnichannel marketplace where CTV, online video and Native ads are traded daily.
Workplace Options is the world's leading employee wellbeing provider. The company provides emotional, physical, and practical support services to over 75 million employees and their families in over 200 countries and territories worldwide.
Vita Health Group is a leading UK provider of integrated physical and mental health services to corporations, the British National Health Service (NHS), and private patients.
