configuration manager

7 Topics

Prerequisites and impact of enabling "Encrypt" in Report Server Database Configuration
Hello everyone, I am currently configuring my Power BI Report Server. In the Report Server Configuration Manager > Change Database wizard, there is an "Encrypt" checkbox for the database connection (as shown in the attached screenshot). I would like to ask: 1. What are the exact prerequisites on the SQL Server side to enable this successfully? 2. Will enabling it cause any downtime or connection issues if not configured perfectly? 3. Does it require a specific SSL/TLS certificate setup on the Database Engine? Any advice or official documentation links would be highly appreciated. Thank you!
Solved
Mohmmadabdr
1 month ago Place Report Server
994Views
0likes
4Comments
Report Server Configuration manager - connect to PostgreSQL server and database
Hi Seems like a really simple task, but unfortunately, this is my first time setting up PowerBI RS. I am having issues making the database connection in the configuration manager to our PostgreSQL database. In the configuration manager in the "Database" section one can only go to "Change Database" button, after that a new prompt appears with "Create a new report server database", "Choose an existing report server database". Since I don't have any database present, I would go with the first one. --> Create a new report server database. After that a page appears (see below), when I try to input the PostgreSQL server IP there I get an error. I know I am doing something wrong, can somebody possibly provide some steps/actions to take to completly configure the database connection.
Solved
IuteJV
1 year ago Place Report Server
3.5KViews
0likes
9Comments
Scale-out option in Report Configuration missing
Hi, After upgrading to Jan 2024 version we are missing the scale-out option in Report Configurator. Anyone knows how to get it back? Just wanted to check that the servers are aware of each other. Seems we are facing issues when reports are lifted into memory on one server and the user is directed to the other server by the load balancer. Everything was working fine in the previous version we had installed (Sept 2023). Best regards, Sören
Solved
SorenHElisa
2 years ago Place Report Server
1.2KViews
0likes
2Comments
No veo la Edicion del Servidor de Informes
Hola que tal; Hace tiempo actualice mi Power BI Report Server de la version de Mayo del 2020 a Septiembre del 2021 a raiz de ese update no puedo ver las opciones que venian debajo de Suscription Settings asi mismo la edicion no me la muestra, realmente necesito saber la edicion para asegurarme que no sea la de evaluacion, ya que anteriormente teniamos instalada esta instancia por medio del software assurance de la compañia. Si existe algun metodo para asegurarme que la edicion instalada no es la de evaluacion agradeceria mucho que me la pudieran proporcionar asi mismo si existe algun metodo para validar esto ultimo se los agradeceria de igualmanera. Espero porfavor me puedan ayudar a la brevedad. Saludos.
Solved
oscarfernandezj
4 years ago Place Report Server
719Views
0likes
2Comments
Report Server Configuration Manager fails to start with .NET Framework error
Sept 2021 Version installed and running for months. Starting the Configuration Manager tool and after connecting to server, I get the following error; Microsoft .NET Framework Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. COM Exception
Solved
RD1965
4 years ago Place Report Server
4.8KViews
0likes
2Comments
Where and what is the webserver for for default Power BI Installation?
Hi Team, I have installed the On Premise Power BI Server and its working fine, but curious to know how is the webserver page is rendering without configuring the iis webserver. Can any one of you let me know the architecture of how power bi is communicating with the webserver. Thank you Sandeep
Anonymous
6 years ago Place Report Server
682Views
0likes
1Comment
Configuration Manager RBAC
With the release of Microsoft Endpoint Configuration Manager 2002, Microsoft added support for integrating Power BI into the Configuration Manager console https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/changes/whats-new-in-version-2002#bkmk_report I installed the Power BI Report Server and configured Configuration Manager to use it following this guide. https://docs.microsoft.com/en-us/mem/configmgr/core/servers/manage/powerbi-report-server Everything works. I can create dashboards and reports querying Configuration Manager views in the SQL database. I want to create a Power BI dashboard that shows statistics of devices, but I only want to show the collections the user has rights to, not all devices/collections. This is easily accomplished in SSRS by enabling RBAC (Role Based Access Control) on the report. The SQL views available in the Configuration Manager database do not support RBAC so instead I need to query Functions. This works when creating SSRS reports, but I cannot for the life of me find out how to do the same thing in Power BI. When creating SSRS Reports, I create a hidden parameter that calls the following code which gets the user's SID, and the SID of any groups they are a member of, from Active Directory: =SrsResources.UserIdentity.GetUserSIDs(User!UserID) How can I call this method on my local Power BI Report Server where the SrsResources.dll is registered? With Microsoft officially supporting Power BI integration with Configuration Manager, configuring RBAC in Power BI should be available. Thanks, Scott
Solved
sfairchild
6 years ago Place Report Server
5KViews
1like
3Comments