Publish to Power BI - Overview

Microsoft Power BI is a suite of business analytics dashboards to analyze data and share insights. The Adobe Analytics integration with Power BI lets you visualize Report Builder Analytics data within Microsoft Power BI and easily share it across your organization.

As an Analyst, previously you would schedule Report Builder workbook distribution using email or ftp. Now you can give your business stakeholders access from within their Power BI accounts, to accurate and up-to-date data in a web-based environment that is accessible across platforms and devices.

Combining the report-generation capability of Report Builder with the visualization features of Power BI makes information more accessible to everyone in your organization. With Power BI, you can also integrate Adobe Analytics with other data sources, for example, point of sale, or CRM sources, to discover unique customer insights, associations, and opportunities.

Diagram of the Microsoft Power BI icon plus the Adobe Analytics icon.

System requirements section_0B71092D853446F38FA36447DAC0D32B

  • Adobe Report Builder 5.5 installed
  • Active Microsoft account that enables you to sign in to Power BI

Publish workbook to Power BI section_21CA66229EC240D49594A9A7D3FBA687

Scheduled workbooks are formatted Excel spreadsheets populated with data from Adobe Analytics that are distributed on a regularly scheduled basis.

Publish workbook in Report Builder

  1. In Report Builder, generate and save a workbook.

  2. On the Report Builder Toolbar, click Schedule > New.

  3. In the Basic Scheduling Wizard, check the box next to Publish Workbook to Microsoft Power BI.

    Screenshot of the Report Builder Scheduling Wizard showing the option to check the Publish Workbook to Microsoft Power BI option.

  4. Specify your email and send immediately or specify the scheduling frequency (hourly, daily, etc.).

  5. Click OK to publish.

  6. You will now be asked to log in to your Microsoft account. Provide your credentials.

  7. The Report Builder workbook gets scheduled and published to Power BI.

    With each scheduled instance, and after the Report Builder scheduling process has refreshed the workbook with updated Analytics data, the workbook will be published to Microsoft Power BI.

View Report Builder workbook data in Power BI

  1. In Power BI, double click the workbook under the Workbooks menu.

    Screenshot of Power BI Workbooks view.

  2. You can now view the workbook dashboard data. The workbook dashboard data.

  3. You can then pin an area of this workbook in order to include it in any of your Power BI dashboards.

Publish all formatted tables in the workbook as Power BI dataset tables section_7C54A54E75184DD6BAEF4ACCE241239A

NOTE
If the workbook contains a macro, the “Publish All Formatted Tables in the Workbook as Power BI Dataset Tables” will be disabled.

Instead of importing the entire workbook, you can import only the content of all formatted tables within the workbook.

Use case: You have an Excel workbook that pulls data from multiple Report Builder requests and creates a summary table with lots of formulas. You can import only the summary table into Power BI and create a visualization for it.

Publish a formatted table in Report Builder

  1. In Report Builder, generate a table of data that includes a header row, followed by a row of data.

  2. Select the table and select Format as Table from the Home menu. The table gets named by default (Table 1, Table 2, etc.), but you can change the name on the Designmenu.

  3. On the Report Builder Toolbar, click Schedule > New.

  4. In the Basic Scheduling Wizard, click Advanced Scheduling Options.

  5. In the Scheduling Wizard - Advanced, on the Publishing Options tab, check the box next to Publish all Formatted Tables as Power BI dataset tables.

    Screenshot showing the Scheduling Wizard - Advanced Publishing Options with the Publish all Formatted Tables as Power BI dataset tables.

  6. (Optional) You can customize the name of the published asset in Power BI. This can be useful if you use versioning as part of the workbook name (e.g., myworkbook_v1.1.xlsx) and you don’t want the version number to show up in the name of the published Power BI asset. It has the added advantage that the published asset will not change if the version number changes. (View specifications here.)

View the table data in Power BI

  1. In Power BI, go to the Workspaces > Datasets menu.

    Screenshot showing the Power BI Datasets menu highlighting Create reports.

  2. Select the dataset that you published and click the Create report icon next to it. Notice that the tables will appear as Fields.

    Screenshot showing selected published dataset listing the tables as Fields.

  3. Select a table and its associated columns.

    Screenshot showing a selected table with associated columns

  4. From the Visualizations menu, you can select how to visualize a table in Power BI. For example, you could choose to present you data as a line graph:

    Screenshot showing the Visualizations menu and a data line graph.

  5. From here, you can create visualizations from this dataset table.

Publish all Report Builder requests as Power BI Dataset tables section_0C26057C7DBB4068A643FDD688F6E463

You can turn all your requests into dataset tables and build visualizations on top of them.

IMPORTANT
If the workbook contains more than 100 requests, only the first 100 requests will be published to Power BI. Plus, for each requests that is published to Power BI, only the first 10,000 rows of data will be published. So while these requests will be successfully delivered through scheduling, the scope of publishing to Power BI is limited.
  1. In Report Builder, open or create a workbook with Report Builder requests.

  2. On the Report Builder Toolbar, click Schedule > New.

  3. In the Basic Scheduling Wizard, click Advanced Scheduling Options.

  4. In the Scheduling Wizard - Advanced, on the Publishing Options tab, check the box next to Publish all Report Builder Requests as Power BI Dataset Tables Screenshot showing the Scheduling Wizard highlighting the Publish all Report Builder Requests as Power BI Dataset Tables option.

  5. Click OK.

View the request data in Power BI

Each scheduled Report Builder request will be published as a table in the dataset. Each request table is named after the primary dimension in the request and it has a Report Suite and a Segments column.

  1. In Power BI, go to the Workspaces > Datasets menu.

  2. Select the request that you published and click the Create report icon next to it.

    Notice that the requests appear as tables in the Fields menu.

    Screenshot showing a selected request published in a two-dimentional, single header row format.

    note note
    NOTE
    No matter how you configured your Report Builder request to be laid out on the worksheet (pivot layout, custom layout, some columns invisible), Report Builder will always publish your request in the same two-dimensional, single header row format: Date, Dimensions, Metrics, Report Suites, Segments.
  3. Also notice that there is an additional table called Legend. If you take a request out of the Report Builder context, it may be difficult to remember what each request stands for. The purpose of the Legend table is, for example, to show you the name of each request under Table ID. You can also add the other Legend columns to get a full view of the request.

    Screenshot showing the Legend table showing the name of each request under Table ID.

recommendation-more-help
a83f8947-1ec6-4156-b2fc-94b5551b3efc