topic Re: Power BI server configuration errors in Report Server

Power BI server configuration errors

sarahryan — Mon, 29 Jan 2018 19:56:00 GMT

Running SQL 2016 and trying to configure Power BI Server (have SSRS on same db instance).

If I try to create a new database I get this error:

Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call (RPC) end point. Verify that the Report Server Windows service is running, and then retry the operation.

---> System.Runtime.InteropServices.COMException: The RPC server is not listening. (Exception from HRESULT: 0x800706B3)

If I connect to an existing database I can configure but get this error trying to view web portal - Service Unavailable

HTTP Error 503. The service is unavailable.

Also the options for backup/change encryption keys are greyed out. Deleting the encrption via config mgr gives me same error as trying to create database. Manually deleting data using sproc in db has no effect.

Please help, it's driving me nuts! I need a working demo as POC in order to purchase but can't get past the first hurdle...

Re: Power BI server configuration errors

v-qiuyu-msft — Fri, 02 Feb 2018 01:19:53 GMT

Hi sarahryan,

Is the Power BI report server installed on the same machine SSRS running?

Regarding the error when you create a database, please follow this article to check if some thing missed: https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/ssrs-report-server-create-a-native-mode-report-server-database

Best Regards,
Qiuyun Yu

Re: Power BI server configuration errors

sarahryan — Fri, 02 Feb 2018 09:07:36 GMT

Yes, Power BI and SSRS on same box.

After I couldn't get Power BI to create a new db due to the error mentioned I uninstalled it and then tried the below steps

I set up an additional SSRS isntance called $PBIRS, orig called $SSRS, both installed on the same db instance. Both of these were correctly setup and configured via RS Config Mgr & the \Report & \ReportServer URLs worked as expected.

For $PBIRS I backed up the encryption key & then used the reportserverPBIRS & reportserverPBIRStempdb databases as the existing databases when I resintalled and tried to setup PowerBI again using Power BI Config Mgr.

Now I can't restore/remove the encryption key (change/restore options greyed out) and the URLs don't work. And it still won't let me create a fresh reportserver db.