Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
We have a scenario where in we would be creating a SQL db per tenant and using PowerBI in multi-tenanted mode (workspace collection, workspace per tenant).
As a result, the reports will be published per client into their respective workspace and pointing to the corresponding database.
This scenario can result in a large number of result datasets being managed by the Power BI service. What are the levers available in the PowerBI service to scale out to a large number of data sets?
What is the internal architecture it uses to handle large scale scenarios? Do we have to explicitly specify storage/compute capacity or specific type and no of nodes to auto scale? We plan on provisioning a node for powerbi embedded as per the report rendering requirements. However how the datasets are managed is not very clear to me.
And the documentation, terminologies for on premise power bi vs azure powerbi service are all confusing, so Im never sure, when I look at an architecture diagram whether it is talking about the Azure PowerBI service or whether its talking about the onpremise architecture of powerbi report server
Hi @alwynpowerbi,
For the sake of performance, there are some limitations of the storage and the size of dataset. Please refer to service-admin-manage-your-data-storage-in-power-bi and service-get-data/#considerations-and-limitations. The Premium would be a good choice for large amount of data.
About embedding, please refer to https://docs.microsoft.com/en-us/power-bi/developer/what-can-you-do.
Best Regards,
Dale
@v-jiascu-msft, yes we evaluating PowerBI premium, to get away from per user licenses.
We are not really expecting largedatasets. Relatively a larger number of users is a more likely scenario that we have to handle.
It appears that PowerBI Premium gives you a single node that can handle datasets as well as dashboards/reports.
As this would mean that we are consuming a dedicated node, I assume that its availability is guareenteed by MS atleast at 99.99%.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |