Power 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-ver15
Power BI Report Server Issues with HA and NLB
Hello everyone, I’ve installed Power BI Reporting Services as a scaled out deployment on two servers with the SSRS DB on a HA Always On Cluster. I’ve used a SSL Certificate for a virtual host name which is provided via a Windows Server NLB Cluster. The configuration are guided by following msdn documentation: https://docs.microsoft.com/de-de/sql/reporting-services/report-server/configure-a-report-server-on-a-network-load-balancing-cluster#ViewState The most time everything works fine. But sometimes I get a “Element not found” error when I navigating between folders on the report manager webpage. Sometimes I get a error when I publish a PBI Report via the Desktop Client. If I close the desktop client and reopen it, mostly it works. If I upload the report via the webpage, it works almost good. Does anyone have a idea? I think there is a misconfiguration with the NLB – is there any best practice settings? Thanks a lot! Bye. PS: The Event Log is clear - client and server side ...