Power BI Desktop “Publish to Pyramid Server” button

Author: | Category: BI Office Feature, Product Tutorials | Tags: analytic platform, data-driven | Published: 7/18/2016

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges, and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment.

Microsoft and Pyramid Analytics have come together to leverage the personal productivity capabilities of Power BI Desktop to enable an integrated, secure, and governed enterprise on-premise or private cloud solution with BI Office.

Users that have a connection to Microsoft Analysis Services (cube or tabular data) can publish a Power BI Desktop visual to BI Office. Once published, that Power BI Desktop visual can be governed and secured. The steps below illustrate how this functionality works.

Step 1 – Creating Power BI Desktop visuals and exporting to BI Office

Power BI Desktop users can Connect Live to a cube or tabular instance (use Recent Sources to open the server after the first time you’ve connected).

Backstage
Figure 1. Opening an existing data source

Here you can open a specific cube or tabular model and begin creating one or more visuals from your data connection. Once your visualization(s) are created, you will be asked to save the .pbix file to a location (your desktop, for example). From there you can publish that file to Pyramid Analytics’ BI Office by entering the BI Office Server name and a content destination and publishing it to the server.

Backstage
Backstage
Backstage
Figure 2. Publishing to Pyramid BI Office server from Power BI Desktop

Step 2 – Integrate Power BI Desktop visual with BI Office Story Board

The Power BI Desktop file is now available for integration into a BI Office Story Board with other content. The file may contain a single visual, multiple visuals tied to the same data set, or multiple pages. By storing the report to the BI Office server, you can secure the Read capability of the report by different AD or non-AD roles in your organization.

Backstage
Figure 3. Securing your Power BI file

Embedding Power BI Desktop content is as simple as dragging and dropping your Power BI Desktop visual into a BI Office Story Board. Specific visual components can be brought in together or separately (NOTE: Interactions between multiple visuals in Power BI Desktop can be maintained ONLY if all views are brought into a Story Board together, not individually).

Backstage
Figure 4. Embedding Power BI Desktop content in a BI Office Story Board

Here the Power BI Desktop content can be dynamically integrated with content from BI Office, such as KPIs and advanced visuals coming from one or more data sets, reporting applications such as Reporting Services, and 3rd party web assets like a corporate intranet. Figure 5 illustrates the interactions from a slice of data driving visuals from a Power BI Desktop visual, a reporting services report, and the KPIs and grid in BI Office. A user would simply select the Slice button and drag and drop interactions.

Backstage
Figure 5. Interactions from a data slice to multiple data sources

(NOTE: Interactions can also be drawn from columns or rows from a BI Office views to a Power BI Desktop visual.)

Backstage
Figure 6. Interactions from a column to multiple data sources


Step 3 – Running your dashboard and showing interactivity

Once created and saved, the BI Office Story Board can be shared by users specified by the analyst when published. As the geography is changed from Australia to the United States in Figure 7, note the changes to the Power BI Desktop view, the BI Office KPIs and grid, and the Reporting Services report.

Backstage
Backstage
Figure 7. Slicers by country (Australia, United States) affecting multiple data sources

Step 4 – Manage a Story Board the Power BI Desktop visual resides in

This content can then be shared via URL and mobile device. All data remains on the server, which allows users to secure the Story Board, track metadata and versioning, and gain telemetry on how users are consuming the BI Office Story Board.

Backstage
Figure 8. Editing versions, security, and lineage

With this new integration, Pyramid Analytics allows you to maximize your Microsoft BI investment, eliminate security concerns, improve manageability, and provide a richer analytics experience through BI Office

Related resources

  1. Video of the feature in action
  2. Best-in-Class On-Premise Business Intelligence for Power BI from Pyramid Analytics webinar
  3. Full training on Power BI Desktop integration
  4. Follow @PyramidAnalytics on Twitter
  5. Subscribe to our blog's feed

Add your comment below

 

Be the first to comment


Stay up-to-date with product announcements

Popup Content