Publish a workbook to a Power BI site and prepare it for Q&A
We’re working to improve Q&A, and will continue to update and refine our documentation as we develop the Q&A service and add new features. If you find errors or have other feedback on the documentation, please let us know!
In Add synonyms to an Excel Power Pivot model you learned how to enhance a Power Pivot data model for Power BI Q&A. In order to use this workbook with Q&A, it must be published to a Power BI site and enabled.
There are several ways to publish a workbook. Two of them are described below. After a workbook is published to a Power BI site, you will then be able to add it as a workbook for Q&A.
Publish a workbook to a Power BI site
In this scenario, you’ll upload the workbook directly into a Power BI site.
Open the SharePoint Online site.
From the left column, select Power BI.
In the Documents area, click add > Upload file and upload your workbook to your Power BI site. While it is uploading, Power BI will display a clock image. When upload is complete, you’ll see a default thumbnail image from your workbook.
The workbook now appears in both your SharePoint Online Documents Library and in the Documents area of your Power BI site.
Publish from Excel and Office 365
In this scenario, you may already have a workbook on your Power BI for Office 365 OneDrive site or in the standard SharePoint Documents view of your Power BI for Office 365 site. Or, you may have added the Power BI sites app to a Power BI for Office 365 site that already contained Excel workbooks that you’d like to make available to Q&A.
If you’re in the standard SharePoint Documents view, in the left navigation bar > Power BI.
In the Power BI sites view, click the ellipsis (…) in the lower-right corner of the workbook > Enable.
Enabling converts the workbook to an interactive format and makes it available as a data source which can be added to Q&A. When this process is complete, Power BI replaces the stock thumbnail image with a default thumbnail image from your workbook.
Add a workbook to Q&A
Before Q&A can use a Power BI workbook as a data source, that workbook must be added to Q&A.
When a question is typed in the Q&A question box or when a Featured Question is selected, Q&A looks for the answer in one or more workbooks. In the image below, Q&A is looking for answers in the Olympics workbook and the WorldBank workbook.
To add a workbook to the list of Q&A data sources,
On the Power BI site, locate the workbook to add.
Left-click the ellipsis (…) and select Add to Q&A.
The selected workbook now appears in Q&A, in the list of data sources.