Connect a report to a semantic model using dynamic binding
Article
06/03/2024
APPLIES TO:
App owns data
User owns data
When a report is connected to a semantic model, you can use dynamic binding. The connection between the report and the semantic model, is known as binding. When the binding is determined at the point of embedding, as opposed to being predetermined earlier, the binding is known as dynamic binding.
When embedding a Power BI report using dynamic binding, you can connect the same report to different semantic models depending on the user's credentials.
This means that you can use one report to display different information, depending on the semantic model it's connected to. For example, a report showing retail sale values can be connected to different retailer semantic models, and produce different results, depending on the semantic model of the retailer it's connected to.
The report and the semantic model don't need to reside in the same workspace. Both workspaces (the one containing the report, and the one containing the semantic model) must be assigned to a capacity.
As part of the embedding process, make sure you generate a token with sufficient permissions, and adjust the config object.
Generating a token with sufficient permissions
Dynamic binding is supported for both Embedding for your organization and Embedding for your customers scenarios. The table below describes the considerations for each scenario.
Scenario
Data ownership
Token
Requirements
Embedding for your organization
User owns data
Access token for Power BI users
The user whose Microsoft Entra token is used, must have appropriate permissions for all items (reports, semantic models, etc.).
The maximum number of data sources allowed per user is 1000. This limit implies that the combined number of datas sources used in the dynamic binding between reports and semantic modelts by this user cannot exceed 1000.
Adjusting the config object
For dynamic binding to work, you need to add datasetBinding to the config object. To learn how this is done, see Bind datasets dynamically to a report.
Related content
If you're new to embedding in Power BI, review these tutorials to learn how to embed your Power BI content.
With Microsoft Power BI, you can use a single semantic model to build many reports. Reduce your administrative overhead even more with scheduled semantic model refreshes and resolving connectivity errors.
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
App owns data