topic Unable to Connect Power BI Report Server through Desktop tool in Report Server

Unable to Connect Power BI Report Server through Desktop tool

saket_mca1 — Thu, 06 Jul 2017 18:05:27 GMT

Hi,

Recently we install Power BI Report Server and Power BI Desktop RS tool on individual machines. We tried to save Desktop report on Power BI Report server using option (Save As -> Power BI Report Server). Since this was the first time we tried to save report on Report server it prompted for Server URL and then click 'Ok'. But it shows one line error message 'Server is not reachable'.

When I tried to use same URL on Browser it worked fine. I tried to look for some fix but didn't get any help.

Please let me know if any face the issue in past.

Regards

Saket

Re: Unable to Connect Power BI Report Server through Desktop tool

v-qiuyu-msft — Fri, 07 Jul 2017 03:10:51 GMT

Hi @saket_mca1,

In your scenario, please go to the machine which hosts Power BI desktop for report server. Then open the browser, type the web portal URL http://<servername>/reports to see if you can access it.

If you can access web portal from the machine hosts Power BI desktop for report server, please try to upload the Power BI report via Upload button.

Best Regards,
Qiuyun Yu

Re: Unable to Connect Power BI Report Server through Desktop tool

Jbielenberg42 — Tue, 11 Jul 2017 15:22:34 GMT

Hi @v-qiuyu-msft,

I am experiencing the exact same problem as Saket, where my report that I would like to host is on one machine, and the report server is on a seperate machine. However, when I tried your proposed solution, the browser says the server refused to connect. Do you have any other solutions to allow me connect my report to the server?

Re: Unable to Connect Power BI Report Server through Desktop tool

JackSprat — Wed, 30 Aug 2017 18:23:16 GMT

Having the same issue. My error is "Unexpected error encountered", when trying to save a Power BI report from the August 2017 Power Bi Desktop app to the August 2017 Power Bi Server.

I am using a direct query report, which can be uploaded successfuly (basically pulled in rather than pushed in), but then I have data connection issues to the Direct Query SQL server, which is also a cryptic error.

Something went wrong

Unable to load the model
Please try again later or contact support. If you contact support, please provide these details.

Request ID2de10e94-cd3f-a5eb-5423-f1ff3c661a43

TimeWed Aug 30 2017 10:43:14 GMT-0700 (US Mountain Standard Time)

Version14.0.600.379

Re: Unable to Connect Power BI Report Server through Desktop tool

JackSprat — Wed, 30 Aug 2017 18:33:55 GMT

I am having the same issue trying to save to the August 2017 PBIRS using the august 2017 PB desktop app. I get

If I use the 'Upload' button inside the PBIRS web page, I get this error when it tries to load data.

Something went wrong

Unable to load the model
Please try again later or contact support. If you contact support, please provide these details.

Request ID2de10e94-cd3f-a5eb-5423-f1ff3c661a43

TimeWed Aug 30 2017 10:43:14 GMT-0700 (US Mountain Standard Time)

Version14.0.600.379

Re: Unable to Connect Power BI Report Server through Desktop tool

JackSprat — Wed, 06 Sep 2017 18:32:29 GMT

This was due to our changing the default service account that runs the PBI server. When we reverted to the default, this issue went away.

Re: Unable to Connect Power BI Report Server through Desktop tool

Anonymous — Tue, 30 Jan 2018 12:11:16 GMT

hi JackSprat,

I'm facing the same issue..can u please explain me the solution you mentioned below:

changing the default service account that runs the PBI server in the sense in sql server configuration manager for sql server(pbi server) we need to change the login to default ?? please help..

thanx in advance..

Re: Unable to Connect Power BI Report Server through Desktop tool

JackSprat — Tue, 30 Jan 2018 15:37:27 GMT

I upgraded to the latest version and that problem was no longer happening. I beleive they have a newer one out now also.

Re: Unable to Connect Power BI Report Server through Desktop tool

bennyraja — Wed, 28 Nov 2018 11:38:00 GMT

Add your powerbi credential in credential manager under windows credential with power BI server URL.

I think this resolve your problem.

I have resolved this issue with this way.

Thanks

BennyRaja.A