Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
alwynpowerbi
Regular Visitor

Azure Power BI Service Architecture

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

2 REPLIES 2
v-jiascu-msft
Employee
Employee

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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%.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors