Power BI Embedded is an Azure service that enables application developers to add interactive Power BI reports into their own applications. Power BI Embedded works with existing applications without needing redesign or changing the way users sign in.
Resources for Microsoft Power BI Embedded are provisioned through the Azure ARM APIs. In this case, the resource you provision is a Power BI Workspace Collection.
Create a workspace collection
A Workspace Collection is the top-level Azure resource and a container for the content that will be embedded in your application. A Workspace Collection can be created in two ways::
- Manually using the Azure Portal
- Programmatically using the Azure Resource Manager(ARM) APIs
Let's walk through the steps to build a Workspace Collection using the Azure Portal.
- Open and sign into Azure Portal: http://portal.azure.com.
Click + New on the top panel.
- Under Data + Analytics click Power BI Embedded.
On the Workspace Collection Blade, enter the required information. For Pricing, see Power BI Embedded pricing.
- Click Create.
The Workspace Collection will take a few moments to provision. When completed, you'll be taken to the Workspace Collection Blade.
The Creation Blade contains the information you need to call the APIs that create workspaces and deploy content to them.
View Power BI API access keys
One of the most important pieces of information needed to call the Power BI REST APIs are the Access Keys. These are used to generate the app tokens that are used to authenticate your API requests. To view your Access Keys, click Access Keys on the Settings Blade. For more about app tokens, see Authenticating and authorizing with Power BI Embedded.
You'll'notice that you have two keys.
Copy these keys and store them securely in your application. It's very important that you treat these keys as you would a password, because they'll provide access to all the content in your Workspace Collection.
While two keys are listed, only one key is needed at a particular time. The second key is provided so you can periodically regenerate keys without interrupting access to the service.
Now that you have an instance of Power BI for your application, and Access Keys, you can import a report into your own app. Before you learn how to import a report, the next section describes creating Power BI datasets and reports to embed into an app.
Working with workspaces
After you have created your workspace collection, you will need to create a workspace that will house your reports and datasets. To create a workspace, you will need to use the Post Worksapce REST API.
Create Power BI datasets and reports to embed into an app using Power BI Desktop
Now that you have created an instance of Power BI for your application, and have Access Keys, you will need to create the Power BI datasets and reports that you want to embed. Datasets and reports can be created by using Power BI Desktop. You can download Power BI Desktop for free. Or, to quickly get started, you can download the Retail Analysis Sample PBIX.
To learn more about how to use Power BI Desktop, see Getting Started with Power BI Desktop.
With Power BI Desktop, you connect to your data source by importing a copy of the data into Power BI Desktop or connecting directly to the data source using DirectQuery.
Here are the differences between using Import and DirectQuery.
|Tables, columns, and data are imported or copied into Power BI Desktop. As you work with visualizations, Power BI Desktop queries a copy of the data. To see any changes that occurred to the underlying data, you must refresh, or import, a complete, current dataset again.||Only tables and columns are imported or copied into Power BI Desktop. As you work with visualizations, Power BI Desktop queries the underlying data source, which means you're always viewing current data.|
For more about connecting to a data source, see Connect to a data source.
After you save your work in Power BI Desktop, a PBIX file is created. This file contains your report. In addition, if you import data the PBIX contains the complete dataset, or if you use DirectQuery, the PBIX contains just a dataset schema. You programmatically deploy the PBIX into your workspace using the Power BI Import API.
Power BI Embedded has additional APIs to change the server and database that your dataset is pointing to and set a service account credential that the dataset will use to connect to your database. See Post SetAllConnections and Patch Gateway Datasource.
Create Power BI datasets and reports using APIs
You can create datasets within Power BI Embedded using the REST API. You can then push data into your dataset. This allows you to work with data without the need of Power BI Desktop. For more information, see Post Datasets.
Get started with sample
Authenticating and authorizing in Power BI Embedded
Embed a report
Create a new report from a dataset in Power BI Embedded Save reports
Power BI Desktop
More questions? Try the Power BI Community