Skip to main content

Error - Power BI Report Server: The Service is not available.The report server can’t connect to its database

I was working on a Power BI Report Server project. Even though it is not the mainstream, It fits well for clients who are reluctant to move to the cloud due to data regulations. Everything was working fine respective to Power BI Report Server configurations. Today, when trying to log in to the "Power BI Report Server Portal", encountered this horrible error 😏

Error Message



The service is not available.

 Contact your system administrator to resolve the issue. System administrators: The report server can’t connect to its database. Make sure the database is running and accessible. You can also check the report server trace log for details.

 First I connected to the report server database and see whether it's up and running. It is working!... Then, I google it and try to find a solution for that. There wasn't a straight forward solution out there as this error message also a genetic one. My next move was digging into this by starting to read the log files. 

 You can find the Power BI report server log files from below path. (If not go each folder by folder to find logs)
C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles



 It was noticeable the exception thrown when validating the integrity of encrypted data. "Deleting encrypted keys" did not work well for me as in one of the community portal answer.  

 In Power BI forum, sashankpappu has given an answer and marked as solution, Install Power BI Report Server in Developer Mode instead of Free Trail for 180 days. (This has to be done while installing PBI Report Server.) for a similar problem.

 However, I can't guarantee what happened during the installation as this installation was done by the client. 

 Luckily 😎 In my case, this is a fresh deployment and I did not have any existing connections/reports deployed in the reporting portal. So,  I straightly go and create a new report server database, which solved this problem. 

After creating a new database, able to connect successfully and access to the Power BI report portal. 

This is not the best solution to this problem. Because, if you have already deployed 25+ reports you are in great trouble 😁. So, if you had the same issue, and figured out what exactly behind it and as well as the solution, please leave a comment about it in the comment section below. Because that helps a lot for me and the readers of this post. Thank you and happy reporting ✌
Labels:

Comments

Post a Comment

Popular posts from this blog

How to Add My Power BI Report in My PowerPoint Presentation?

Had a great week after conducting two-day sessions on Data Warehousing and How to do Business Intelligence with Microsoft Power BI . During the sessions, I got an interesting question from the audience. The question was “how its possible to show the Power BI report or visuals in my Powerpoint slides, at the same time the data need to be up-to-date same as in report”. I love these sort of questions and find solutions because these are real-world problems they have. I thought to write a simple post to address that problem, and in this post, I explain how to achieve it. Pre-requisites You have already Power BI report created and published to the Power BI service. If you missed how to do it read this blog . If your source is a file like Excel or CSV the deployment is even simple. You don't want to worry about to configure the gateway and you can simply click Publish and publish your report. Steps to Follow Open the MS PowerPoint and go to Insert tab and My-Addins It will ...
2 comments
Read more

Get Started with Azure Machine Learning

Azure Machine Learning is a Microsoft cloud solution which allow us to do end-to-end experiments using the samples, experiments provided. Further, it allows us to write custom algorithms using popular data science languages like R and Python.  Lets start to create preview account on Azure and create Azure Machine Learning Experiment workspace. Microsoft gives 30 days trial period for free to do experiments on Azure. You can start to create an Azure account from here. When you sign-up you might need to provide credit card details that only for validate the user. As far as I know we only need to pay if we are going to upgrade the free subscription for Pay-as-you-go model. Lets start to create a machine learning experimentation. For that click on left down below "More services" and from the search bar, type "Machine Learning". Then click the Machine Learning Experimentation in order to create new environment. Then it will open new blades to provide d...
1 comment
Read more