Enable Power BI Service Settings
Give the Reporting Hub permission to access Power BI
Last updated
Give the Reporting Hub permission to access Power BI
Last updated
For Reporting Hub (an Azure AD app) to access Power BI content and APIs, a Fabric or Power BI Admin needs to enable the following settings:
Go to Tenant settings in the Power BI , and scroll down to Integration settings.
Enable the Allow XMLA endpoints and Analyze in Excel with on-premises datasets toggle either for the entire organization or for the specific security group you created in Azure Entra ID.
Enable the Embed content in apps toggle either for the entire organization or for a specific security group you created in Azure Entra ID.
Enable the Service principals can create workspaces, connections, and deployment pipelines toggle either for the entire organization or for the specific security group you created in Azure Entra ID.
Enable the Service principals can call Fabric public APIs toggle either for the entire organization or for the specific security group you created in Azure Entra ID.
Enable the Allow service principals to create and use profiles toggle either for the entire organization or for the specific security group you created in Azure Entra ID.
Enable the Enhance admin APIs responses with detailed metadata toggle either for the entire organization or for the specific security group you created in Azure Entra ID. To learn more about the Admin API Settings, visit the Microsoft link below the screenshot.
There are three steps you need to perform in order to make your Power BI workspaces available in Reporting Hub.
To add a Power BI workspace to a capacity, you'll need to:
Navigate to the workspace you integrate with Reporting Hub. If this is your first time using Reporting Hub, it is recommended to integrate a non-production workspace.
Click on the three-dot menu, and choose Workspace Settings.
On the License Info tab, the license mode to Embedded or Fabric. If you have more than one embedded capacity, select the one that is being managed by Reporting Hub and click Apply.
After assigning the capacity as the workspace license, you need to give your Reporting Hub application access to the workspace.
In your Reporting Hub application, navigate to App Settings > App Information.
Copy the Name of your service principal and note the Client ID.
Click on the three-dot menu, and choose Manage Access > + Add people or groups.
In the 'Enter name or email' field, paste the Name that you copied from your application and select the one that shows an AppID under the name. If you see multiple apps with the same name, select the one with the AppID that matches the Client ID in your app.
You must set the permission to either Member or Admin. Click Add.
Now that your workspace is added to your capacity and you have granted your Reporting Hub application permission, you will need to assign the workspace to your Reporting Hub Global Tenant.
Log in to:
If capacity is greyed out: The capacity selection will only be visible to you if you are a and the . If the capacity is paused, you can start it by either going to the Azure portal and starting the capacity or by signing into Reporting Hub, and the application will start the capacity automatically.
Navigate back to the workspace in the . Ensure this is the same one from first step.
Service principal not showing up? Ensure you have enabled your and that your setting is either enabled for the entire organization or that the application service principal you want to add is a member of one of the specified groups.
We will go through this in the next step, in .