Publish report to Power BI

One of the most requested features by users is the ability to publish Power BI reports that are stored locally on their computers to workspaces in Power BI service, giving users greater freedom and autonomy.

For this reason, Power Embedded now offers this functionality to all customers.

Publishing Power BI Reports

To publish Power BI reports directly through Power Embedded, go to the Reports page.

Click the Import > Power BI File button.

In the screen that opens, select the file you want to publish.

After that, select which workspace you want to publish the report to.

Now you need to define what to do if a semantic model with the same name as the file you are importing already exists:

• Ignore (create with the same name): If a dataset with the same name already exists, the import operation will create a new dataset with the same name.

• Cancel the upload: If a dataset with the same name already exists, the import operation will be cancelled.

• Create or overwrite: If a dataset with the same name already exists, the import operation will replace the existing dataset with the new one. The import operation will fail if there is more than one existing dataset with the same name.

Finally, you can check the option Create only the semantic model (do not create the report), if you only want to publish the semantic model without automatically creating the report (which is the Power BI default).

How to create a storage account

Click here to view this topic

Before configuring the integration between Power Embedded and the storage account, you will need to create your storage account in the Azure Portal.

To create it, you can use the default values, as shown below:

Enable the option Allow enabling anonymous access on individual containers:

You can review the other settings, but for the purposes of this tutorial, you can proceed and complete the storage account creation.

After creation, access the storage account you created.

Expand the Data storage section and select the Containers option.

Click the +Container button.

Enter the name of the container you want to create and click the Create button at the bottom of the screen.

Make note of the container name in a notepad, as you will use it later to configure the storage account.

Expand the Security + networking section and select the Access keys option.

On this screen, copy and save in a notepad the values of the Storage account name and Key fields (you need to click the Show button to copy the key), as we will use these values to configure the storage account.

Now expand the Settings section and select the Resource sharing (CORS) option.

Fill in the fields as shown in the image above:

• Allowed origins: https://admin.powerembedded.com.br

• Allowed methods: PUT

• Allowed headers: *

Storage account configuration

Click here to view this topic

To publish the reports, Power BI needs to temporarily upload the Power BI file from your computer to an Azure storage account.

After this upload, Power Embedded makes a call to the Power BI API, informing the URL of the file in the storage account (Azure Blob Storage) to import into the workspace. After the import, the file is deleted from temporary storage.

By default, a storage account owned by Power Embedded itself is used for this temporary storage of Power BI files. Therefore, you do not need to create or configure a Power Embedded integration with a storage account.

However, it is understandable that you may prefer to use your company's storage account, for security and data privacy reasons, to temporarily store the files that will be uploaded and subsequently published to Power BI service.

This integration using your company's storage account can be configured on the screen below, which is found on the Settings page > Parameters tab:

\

Open the notepad with the information you saved and now you can configure your integration between Power Embedded and the temporary storage account you created.

Example of this configuration screen with the information properly filled in:

Done! Your users can now publish Power BI files through Power Embedded.