Publish to Power BI - Overview
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.
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.
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
-
In Report Builder, generate and save a workbook.
-
On the Report Builder Toolbar, click Schedule > New.
-
In the Basic Scheduling Wizard, check the box next to Publish Workbook to Microsoft Power BI.
-
Specify your email and send immediately or specify the scheduling frequency (hourly, daily, etc.).
-
Click OK to publish.
-
You will now be asked to log in to your Microsoft account. Provide your credentials.
-
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
-
In Power BI, double click the workbook under the Workbooks menu.
-
You can now view the workbook dashboard data.
-
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
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
-
In Report Builder, generate a table of data that includes a header row, followed by a row of data.
-
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.
-
On the Report Builder Toolbar, click Schedule > New.
-
In the Basic Scheduling Wizard, click Advanced Scheduling Options.
-
In the Scheduling Wizard - Advanced, on the Publishing Options tab, check the box next to Publish all Formatted Tables as Power BI dataset tables.
-
(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
-
In Power BI, go to the Workspaces > Datasets menu.
-
Select the dataset that you published and click the Create report icon next to it. Notice that the tables will appear as Fields.
-
Select a table and its associated columns.
-
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:
-
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.
-
In Report Builder, open or create a workbook with Report Builder requests.
-
On the Report Builder Toolbar, click Schedule > New.
-
In the Basic Scheduling Wizard, click Advanced Scheduling Options.
-
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
-
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.
-
In Power BI, go to the Workspaces > Datasets menu.
-
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.
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. -
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.
