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 / Add Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint

Add Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint

published on 28/08/2017 by Remo Knops

How can you add Power BI Tiles & Reports in your Microsoft Excel, PowerPoint Documents or on a SharePoint site?

Rui Romano of DevScope has built an application that allows you to insert Power BI visualizations into Office documents.

Devscope Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint 6

Table of Contents hide
Power BI Tiles COM Add-in from DevScope
Power BI Tiles for Microsoft PowerPoint
Power BI Tiles for Microsoft Excel
Concluding thoughts and wrap-up
Related Posts

Power BI Tiles COM Add-in from DevScope

You can get the Power BI Tiles & Reports COM Add-in by clicking the add button in the Office Store or you can search for the plugin from the store button in the ribbon of Microsoft Excel or PowerPoint. On my Microsoft Surface Pro 3 I find the store option in the File tab of the Office Ribbon. The COM Add-in places itself in the Insert tab of the Microsoft Excel or PowerPoint ribbon.

If you choose to install the Power BI Tiles COM Add-in from DevScope by hitting the store button, you need to install it manually in Microsoft Excel and manually install it in Microsoft PowerPoint. In other words two installations. 🙂

Devscope Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint 7

Power BI Tiles for Microsoft PowerPoint

After installation of the COM Add-in from the Office store you open Microsoft PowerPoint and go the the Insert Tab of the Office Ribbon. On the right you see the Insert Power BI Tiles button. When you click on it you will get a yellow DevScope Power BI Tiles pop-up window with a few options.

You can “Add Power BI Tiles & Reports in your Office Documents” using a couple of options:

  • From Power BI
  • From a Public Report
  • Download

I used the first option, which redirects you the the Office 365 login screen. This step does the authentication with Power BI and you need to grant the Power BI Tiles COM Add-in permissions to read your reports in order to insert your visualizations.

After the authentication step you can choose the visualizations from your Power BI Dashboard that you would like to share. If you want to add more visualizations you simply add another container via the Insert Power BI Tiles button.

Devscope Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint 2

Power BI Tiles for Microsoft Excel

Rui Romano has build also a version of the COM Add-in for Microsoft Excel. I’ve tested it and it works exactly the same as described in the above section of Power BI Tiles for Microsoft PowerPoint.

While it can be useful in some usage-scenarios (for example when you distribute Excel Workbooks) it can be useful to add a visualization from Power BI. Personally I think that most analysts and data professionals do a lot of their hard reporting and analysis in Microsoft Excel. So I publish tables and simple charts to Power BI using Power BI publisher for Microsoft Excel.

But I have the Power BI Tiles COM Add-in for Microsoft Excel installed anyway, so I can do the complete round of exchanging data and visualizations.

Devscope Power BI Tiles in Microsoft Excel, PowerPoint and SharePoint 4

Concluding thoughts and wrap-up

With the Power BI Tiles COM Add-in from DevScope you can add interactive tiles from your Power BI dashboards easily to your Microsoft PowerPoint slides or Microsoft Excel workbook.

Personally I see the most value in the ability to add Power BI dashboard tiles to a PowerPoint presentation. I often do the hard calculations or data structuring in Microsoft Excel and perform the visualizations in Power BI, or simply publish charts and tables to Power BI with Power BI publisher for Microsoft Excel. This means that I personally don’t use the DevScope Tiles add-in for Excel a lot.

  • Power BI Tiles for Microsoft Excel and Microsoft PowerPoint is free
  • Power BI Tiles for SharePoint isn’t free but can be installed from the Office Store for a small fee of $2.99/month.

I haven’t tested the Power BI Tiles for SharePoint Add-in. However I can see excellent value if you are collaborating a lot with your team through SharePoint sites.

Other cool COM Add-in for Microsoft Office I’ve recently reviewed are:

  • Power BI publisher for Microsoft Excel
  • Transform Data by Example for Microsoft Excel
  • Onetastic is addin for Microsoft OneNote

Finally you can check out the pptPlex COM Add-in that give Microsoft PowerPoint Prezi-like capabilities (still works with Microsoft Office 2016). 🙂

Interested in other software reviews?

Check out this page with the software review table.

remo_knops_segoe_script_18px

 

 

 

 

Related Posts

  • Power BI publisher for Microsoft Excel
  • Power BI - Visualize your data
  • Power BI Helper - RADACAD Cleanup Tool for Power BI
Email
Share4
Tweet5
Share5
Buffer
WhatsApp
14 Shares

Filed Under: Business Intelligence, Office Tagged With: DevScope, Power BI, Rui Romano

Leave a Reply Cancel reply

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

Search

Related Posts

  • Power BI publisher for Microsoft Excel
  • Power BI – Visualize your data
  • Power BI Helper – RADACAD Cleanup Tool for Power BI

POPULAR POSTS

  • How to Install Speedplay Zero Walkable Cleats on Sidi Wire SP 10 views
  • Process Model Canvas – Marco Bijl, James P. Devlin and David Ruting 7 views
  • Microsoft Planner – Install as app on Windows 10 with Microsoft Edge Chromium 7 views
  • Bosch Blauw GLI 12V-300 LED – Professional Light 7 views
  • Wera 813 small Kraftform Kompakt handle with 1/4″ bit holder 6 views
  • Who moved my cheese ? (Johnson) Book review 4 views
  • Elite Fly Team Water Bottle review 3 views
  • Business Analyst and Enterprise Architect – Cats and dogs ? 3 views
  • The 6 Habits of Growth – Audible Book of Brendon Burchard 3 views
  • Onetastic addin for Microsoft OneNote 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