Power BI Publisher for Excel

Publish Excel to Power BI

Update: Publish your Excel (M365) reports to Power BI Service

The Excel Pulisher to Power BI Service is not available as an add-in anymore. It is now a built-in feature within the Excel app itself.

You can now publish your Excel reports directly from the Excel itself into your Power BI Service. Follow the steps below:

1- Click File menu then click Publish
2- Click Publish to Power BI
3- Select a Workspace you’d like to publish the report from the dropdown
4- Click Upload

Publishing Excel reports to Power BI Service

After the report successfully published to your Power BI Service, a yellow message shows up in Excel. You can click the Go to Power BI button.

Go to Power BI after Publishing Excel reports to Power BI from Excel

5- From your Power BI Service, click to open the published Excel report in Power BI Service

Opening a Published Excel report in Power BI Service

6- Select a chart
7- Click Pin
8- Select an Existing dashboard or New dashboard
9- Click Pin

Pinning a chart from an Excel report to Power BI Dashboard

All Done! If you navigate to your Power BI Dashboard, the pinned charts must appear on the dashboard.

Pinned charts in Power BI DashboardIf you’re using the older versions of Excel then continue reading.

It’s been awhile that lots of Excel users were wondering if there is a way to include their Excel elements into Power BI dashboards. With Power BI Publisher for Excel you’re now able to publish snapshots on your important PivotTables, Charts, cell ranges etc. to your Power BI Dashboards. In this post you’ll learn how to get the job done.

How does Power BI Publisher for Excel works?

With the Power BI Publisher Excel you take snapshots of your important insights in Excel and Pin them in Power BI Dashboards.

You need to download and install the Power BI Publisher for Excel from here.

What Excel elements you can/cannot pin?

You can pin almost everything in your Excel worksheet including:

  • A range of cells (from a simple sheet, from a table or a pivot table)
  • Pivot charts
  • Illustrations and images
  • Text

However, you cannot pin 3D Maps or visualisations from Power View.

Note: Although you can pin almost everything from your worksheet to a Power BI Dashboard it doesn’t make sense to pin some elements like Slicers or Timeline filters.

Enabling Power BI Publisher for Excel

The Power BI Publisher for Excel add-in should be enabled by default, however, if for some reason it is not enabled you can manually enable it as below:

Power BI Publisher for Excel 01

Sign in to Power BI Service with Your Account

To be able to pin your Excel elements to your Power BI dashboards you need to sign-in to your Power BI Service. When you open Excel for the first time after installing the publisher you’ll prompt to sign-in.

Power BI Publisher for Excel
  • Click “Sign In”
  • Enter your account name then click “Sign In” again
Power BI Publisher for Excel 02
  • Click “Work or School account”
Power BI sign in
  • Enter your password and “Sign In”
  • Click Close
Power BI Publisher for Excel 03

If for any reason the sign-in form didn’t get through then:

  • Click “Power BI” tab from the ribbon
  • Click “Profile”
  • Click “Sign In” then follow the above steps
Power BI Publisher for Excel 04

Pin a Range/charts to a Power BI Dashboard

You can select and pin any range of cells from your worksheets to your Power BI Dashboard.

 

  • In you r Excel worksheet select a range
  • Click “Power BI” tab from the ribbon
  • Click “Pin”
  • If you are not already singed into Power BI service you’ll be prompted to
  • Select an existing dashboard or create a new one
  • Click “Pin”
Pin to Power BI
  • To pin a chart just simply click a chart then click Pin from Power BI tab
Pin to Power BI 01

Now sign into your Power BI service using to see the tiles you pinned from Power BI Publisher for Excel.

Power BI Dashboard with Excel Tiles

Can I Refresh the pinned elements?

Yes you can. It is super easy. just select the element and pin it again. You’ll be prompted that the tile already exists in the dashboard and you have the option to update the existing one or add a new tile. To update an existing tile select “Update tile” then click OK.

Refresh pinned elements

You can also refresh multiple elements through Pin Manager which is explained below.

Managing Pinned Elements

You can refresh an element which is already pinned to a dashboard or you can remove it. You can also select multiple elements and update or remove all of them by following the steps below:

  • Click “Pin Manager” from “Power BI” tab from the ribbon
  • Select one or more elements then click “Update” to update and “Remove” to remove the pinned tiles from the Power BI Dashboard
Pin Manager

Switch between Power BI Accounts

You can switch between Power BI Accounts to pin Excel elements.

  • Click “Profile” from “Power BI” tab
  • Click “Sign out”
Power BI Account in Excel Publisher
  • Click “Sign In”
  • Enter the new account and sign into the Power BI Service normally
  • Select a Chart or Range and click pin
  • Now click “Pin Manager”
  • As you can see the elements you pinned to a dashboard when logged in to your previous Power BI account are exist in the Pin Manager with a warning icon on the right side, so if you want to switch to the new account forever, you can select the old elements and remove
Remove Elements from Pin Manager

Note: Removing a pinned element does NOT remove the associated tile in Power BI. So to remove the tiles from the old Power BI account you need to sing into that account and remove the tiles manually.

Removing Pinned Elements

8 thoughts on “Power BI Publisher for Excel

  1. Hi,
    is there a way to have power bi automatically refresh the excel data and then the pinned excel objects?

    Thank you,
    Roberto

    1. Hi Kazouane,

      Welcome to BIInsight.com and thanks for your comment.
      I wrote this post a long time ago and I totally forgot about it so I didn’t updated the content until reading your comment. So thanks for that. ?
      Please have a look at the post that I updated today.
      Hopefully it helps.

      Cheers.

      1. Hi,

        Is it true that the Power BI Publisher add-in for Excel is not supported and cannot be installed anymore since 2020? so can i pin charts from the excel file right up into power bi dashboards directly instead of publishing it then pin it into dashboards ?
        I can’t find a link to download the Power BI Publisher for Excel to make a test

        Thank you for your response

        1. Hi Yasmine,

          That’s right, I updated this post with the instructions on how to publish an Excel report to Power BI Service and how to Pin the Excel charts to Power BI dashboards.
          Hopefully that helps.

          Cheers

    1. Hi Leo,

      Thanks for your comment. But this is an old blogpost.
      You can now publish your Excel reports to Power BI Service using the native publishing feature available in Excel as the following screenshot shows:

      Publishing Excel to Power BI Service

      Hopefully that helps.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.