Back
Excel

Power View interactive visualizations and PivotTables can now be embedded in blogs and websites

Share on Facebook Share on Twitter Share on Linkedin Share via OneNote Share via Email Print

Today’s post was written by Eli Schwartz, lead program manager and Tsur Arieli, program manager on the Excel product team.

Embedding Excel spreadsheet tables and charts in a webpage or blog is a popular and well-known feature, which has allowed companies and individuals to share data and visualizations to public audiences in effective ways. But telling a story with data has become so much more than basic tables and charts. Some of you have been using Power View to create dynamic and interactive visualizations or shared PivotTable analysis based on your data models. But you have not yet had a way to share these publicly. Excel now offers all Office 365 Enterprise E3 or SharePoint Online Plan 2 subscribers with an option to embed the Power View interactive visualizations and PivotTables you’ve created in your workbooks (10MB or smaller). Imagine if you could display interactive visualizations, like these examples, to your audience or customers.

Embedding is easy. Simply start by uploading your workbook to SharePoint, then use the share option to generate a URL. Create an iframe based on the new URL with the parameters action=embedview and wdbipreview=true. You also can customize how your visualizations are displayed to better fit your embedded workbook to your website or blog. See our getting started instructions for more information.

Please note, as the support for this feature is evolving, heavy traffic might result in viewers of your hosted workbook being throttled. While you should expect support for 1,000 concurrent viewers, you may experience variability with as many as 10,000 concurrent viewers being supported in the best case.

———————————————-

Power View is part of several analytics and visualization features in Excel that is available with an Office 365 ProPlus subscription. Power BI for Office 365 provides your company with more advanced business intelligence capabilities, including automatic refreshing of your hosted Power View reports, searching corporate data directly from your Excel workbook, and using natural language to get immediate BI insights anytime and anywhere.

For more information:

—Eli Schwartz and Tsur Arieli

Top

Join the conversation

5 comments
  1. Are workbooks that are connected to Power Pivot data models supported?

    Thank you.

    Arthur Jenkins

    • Yes. As long as the data model is inside the workbook. External data models are not supported.
      Tsur.

  2. Is it possible to embed a workbook using this method in all the countries?
    I’ve tried it in Spain with an Office 365 Preview and I’ve received this message:

    This content cannot be displayed in a frame.
    To help protect the security of information you enter into this website, the publisher of this content does not allow it to be displayed in a frame.

    Thank you.

    • I can access the url if I open the browser in a private mode, so the workbook is well published in Office 365.

      • Now, it works correctly in a iFrame in a SharePoint 2013. No more error message.

        Tsur, thank you for your interest.

Comments are closed.