scale
4 TopicsPower BI Report Server - Scalability, Load Balancing, Clustering & HA, Encryption
Hi all, Good day. Faily new to this Power BI Report Server game, would appreciate if you can assist on the following query. Is Power BI Report Server works the same way as SSRS, in term of scalability, load balancing, clustering and HA, as well as data encryption? I have seaerched through the community, able to gathered the following informing, but mainly on SQL server or SSRS. Do we have any document/link that is focus on Power BI Report Server with the required information? Thanks. HA https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server?view=sql-server-ver15#bkmk_reportserverdatabases https://docs.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver15 Scale out https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15 https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms159114(v=sql.105)?redirectedfrom=MSDN https://docs.microsoft.com/en-us/power-bi/report-server/capacity-planning Data Encryption https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-encryption-keys-initialize-a-report-server?view=sql-server-ver152.5KViews0likes1CommentHelp! How to configure a ScaleOut for a Data model Refresh
Hi All, We need to have the following configuration with 2 servers where PBIRS is installed : The first one acts as a Front-End server (interactive report processing) The second one acts as a back-End server, in particular it accepts all the data model refresh requests (scheduled report processing). On the PBIRS confirmation of each server, the scale out section contains both servers Question is: How can we force that the first one is used for interactive report processing and the second one will perform the data model refresh? Microsoft documentation is the following (but not clear to me): https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/configure-a-native-mode-report-server-scale-out-deployment?view=sql-server-ver15 Thanks for your help! KarimSolved1.1KViews0likes1CommentHow to scale out Power BI Report Server?
Hi, How can I scale out Power BI Report Server? I am running an instance on a VM and have added 8 cores to the instance but Report Server is still only running off one of the cores with no performance boost. What am I missing? Do I need to change something in the .config files? thanks, MattSolved11KViews0likes4Comments