Remo Knops

MENUMENU
  • Home
  • About
  • What I use
  • Contact Me
  • Disclaimer

Personal Blog

  • Facebook
  • Flickr
  • Instagram
  • LinkedIn
  • RSS
  • Twitter
MENUMENU
  • Innovation
    • Business Analysis
    • Business Intelligence
    • Innovation Tools and models
  • Entrepreneurship
  • Personal Development
  • Books
  • Cycling
    • Cycling Reviews
    • How I test and review on www.remo-knops.com
You are here: Home / Microsoft / Office / Power BI publisher for Microsoft Excel

Power BI publisher for Microsoft Excel

published on 19/06/2017 by Remo Knops

Power BI publisher is a COM Add-in for Microsoft Excel that integrates in the Microsoft Office Ribbon. You can easily pin snapshots of PivotTables, charts, cells, cell ranges, and more to a Power BI dashboard with just a few clicks from Excel workbook.

A little while ago I provided an overview of Microsoft Power BI (and its components) and how it can help you and any organization to visualize data, and draw informed decisions based on these insights.

Power BI Publisher for Microsoft Excel 118

Table of Contents hide
Power BI Publisher for Microsoft Excel
Ribbon Power BI Publisher
Pin
Power BI
Settings
Concluding thoughts and wrap-up
Related Posts

Power BI Publisher for Microsoft Excel

“Save snapshots of important PivotTables, Charts, cell ranges, and more from across all of your spreadsheets to a single location with Power BI publisher for Excel. Just download and install the add-in, and you’ll be pinning data from your workbook to your own Excel dashboard in seconds. Your new dashboard is easy to update and share, and comes with all of the features of the free Power BI service, such as combining multiple sheets on a single dashboard and connecting to live data from other web apps you use.”

Power BI Publisher for Microsoft Excel 139 - Copy

Ribbon Power BI Publisher

The Power BI Publisher COM Add-in is visible in the Microsoft Excel Ribbon, and has three main sections:

  1. Pin
  2. Power BI
  3. Settings

Power BI Publisher for Microsoft Excel 136

Pin
  • Pin;
  • Pin Manager;

In the Pin section you can execute the pin command for selected cells, tables, charts or objects in your Excel workbook. In the pop-up window you can select to pin it to an existing Power BI dashboard or create a new Power BI dashboard, while the Pin Manager gives you an overview of all pinned items in the workbook.

Power BI Publisher for Microsoft Excel 140

Power BI
  • Open Power BI
  • Connect to Data
  • Profile

You can open your Power BI workspace by clicking on the Open Power BI button (where I personally would expect also the option to open Power BI Desktop). Via the connect to data button you can connect to reports or data sets from within your Microsoft Excel workbook. So now you can connect both ways (from Power BI Desktop to an Excel sheet and visa versa). The profile button simply  has the credentials of your Power BI Workspace.

Power BI Publisher for Microsoft Excel 131

Settings
  • Update
  • About

In the settings section you can trigger a Power BI Publisher update from the update button (is greyed out when you have the latest version installed). And about shows you the Power BI Publisher version you are running.

Power BI Publisher for Microsoft Excel 138

Concluding thoughts and wrap-up

Power BI Publisher for Microsoft Excel is a must have COM Add-in if you work with data and Power BI.

While it was possible to connect to Microsoft Excel worksheets (as a data source) in Power BI, it wasn’t possible to publish Excel objects directly to your Power BI workspace. Power BI Publisher for Microsoft Excel fills that gap providing a two way route. If you prefer to do some analysis in Microsoft Excel, you can share it to a Power BI dashboard.

Also check out David Iseminger‘s blogpost “Power BI publisher for Excel” that includes a good set of screenshots and release notes.

What do you think of Power BI Publisher for Microsoft Excel ?

remo_knops_segoe_script_18px

Related Posts

  • Power BI - Visualize your data
  • Add Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint
  • Power BI Helper - RADACAD Cleanup Tool for Power BI
Email
Share
Tweet2
Share
Buffer
WhatsApp
2 Shares

Filed Under: Business Intelligence, Office Tagged With: COM Add-in, David Iseminger, Power BI

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Related Posts

  • Power BI – Visualize your data
  • Add Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint
  • Power BI Helper – RADACAD Cleanup Tool for Power BI

POPULAR POSTS

  • Microsoft Planner – Install as app on Windows 10 with Microsoft Edge Chromium 8 views
  • Renpho Smart Scale syncs metrics via Fitbit API to TrainingPeaks 6 views
  • Tune Wasserträger 2.0 Carbon Bottle Cage review 5 views
  • Waterfield Micro Wallet review 5 views
  • Business Model You – Tim Clark 4 views
  • Onetastic addin for Microsoft OneNote 4 views
  • The One Minute Sales Person (Johnson & Wilson, 1984) 4 views
  • BBB LinkFix BTL-77 pliers for KMC Missing Link 4 views
  • What is a Business Model ? 4 views
  • Who moved my cheese ? (Johnson) Book review 3 views

Popular Shared Posts

CEMA Bearing Bottom Bracket Replacement Tool169 Total Shares
Operating Model Canvas book review – Andrew Campbell, Mikel Gutierrez, Mark Lancelott121 Total Shares
Design a Better Business – Book review71 Total Shares
The Secret of Cycling – Vroemen, Van Dijk, Van Megen50 Total Shares
Who moved my cheese ? (Johnson) Book review48 Total Shares
Mark J. Owen – Business Analysis Wisdom eBook42 Total Shares
C-Bear Bottom Bracket for BB86/BB9238 Total Shares
Aspiring Advisor Book Review – Moritz Dressel37 Total Shares
Onetastic addin for Microsoft OneNote36 Total Shares
Elite Fly Team Water Bottle review33 Total Shares

Copyright © 2023 ·Minimum Pro · Genesis Framework by StudioPress · WordPress · Log in