Skip to main content
Skip to main content
Microsoft 365

Share your Excel insights with Power BI

The Excel and Power BI teams have been busy releasing capabilities and tools that allow you to share your Excel data and insights to Power BI more quickly and easily.

Here are a few new ways in which Excel and Power BI work better together:

Share your Excel insights with Power BI publisher for Excel

With Power BI publisher for Excel Preview—just announced two weeks ago—you can save snapshots of important PivotTables, charts, cell ranges and more from across all of your spreadsheets to a single location quickly. Select a range or an element in your workbook and, under the Power BI tab, click Pin.

Share your Excel insights with Power BI 1

Next, select an existing dashboard from the list or create a new one, click the Pin button and you’re good to go.

Share your Excel insights with Power BI 2

Power BI publisher for Excel also allows you to keep your pinned elements up to date with the Pin manager. Download Power BI publisher for Excel to get started today.

Pin Excel elements to your Power BI dashboard

Last November, we announced the ability to pin Excel ranges, tables and charts to your Power BI dashboards. No need to re-format or rebuild your Excel reports—simply upload to Power BI, select a range, a table or a chart, click the Pin button and your Excel tile is now part of your dashboard.

Share your Excel insights with Power BI 3

Using Excel reports on Power BI not only allows you to pin content to your dashboards, you can view spreadsheets when you click the respective tile. You can also personalize the way your Excel tiles look and feel, open your Excel reports directly from Power BI or even add Excel workbooks to organizational Content Packs.

Publish to Power BI from Excel 2016

Last but not least, last September we announced the ability to effortlessly publish your workbook content to Power BI directly from Excel 2016.

Share your Excel insights with Power BI 4

Once your workbook is published, you can keep working on it in OneDrive for Business. Power BI automatically refreshes when you make updates to your workbook.

To publish your Excel workbook to Power BI, simply select File > Publish.

Can’t wait to try these out? Sign up for Power BI and try the new Excel.

Stay tuned for more Excel + Power BI updates and let us know what you think.

Additional resources

And last but not least, join us for the inaugural Microsoft Data Insights Summit on March 22–23 in Bellevue, Washington, and discover new ways to bring your data to life. This will be the first Microsoft Power BI and Microsoft Excel user conference designed especially for you, the business analyst.

You may also like these articles

Image for: View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

View live transcripts in Microsoft Teams meetings, track Excel changes, and increase hybrid work security—here’s what’s new to Microsoft 365

This month, we're announcing some top requested features like tracking changes in Excel and live transcriptions in Teams, as well as some soon-to-be-favorites like meeting recaps, turning Word documents in presentations, and more.

Image for: Family hanging out at home baking holiday cookies using Lenovo Ideapad Flex 3 to make holiday cards

New apps and features in Microsoft 365 for individuals and families this fall

Since we introduced Microsoft 365 to individuals and families earlier this year, we have continued to deliver new innovations across our apps and services to help you and your family save time and stay connected. See what’s new below. Locate your loved ones and build better driving habits with Microsoft Family Safety Stay connected even…

Image for: A man is using his Lenovo laptop like a tablet while sitting in a comfortable chair in a Modern office setting

Microsoft Productivity Score and personalized experiences—here’s what’s new to Microsoft 365 in October

As I reflect on an action-packed few weeks, I’m struck by how much work has evolved in these past months. And I know our customers feel it too. After quickly moving to remote and hybrid work models this spring, organizations are now seeking sustainable ways to help people collaborate, be productive, and prioritize their wellbeing…