topic Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As in Report Server

Unexpected Error Power BI report Server With Desktop While Connecting/Save As

Anonymous — Wed, 22 May 2019 06:48:57 GMT

I have configured the Power BI report server with custom authentication and I am able to browser reports and upload reports from Desktop version and optimised dektop version from the web url.
But when I try to connect or save as to report server from the optimised desktop version (Jan 2019), I always the error "Unexpected error encountered". I have seen the log files and below is the error message(s).
 
I am also getting the same error when I am trying to edit the report from browser and opening it in the optimised desktop version for power bi server.
 
I am using the latest version of Power BI report server, desktop version and optimised desktop version.
 
Can somebody please help me on this as I am really struggling to understand, why it is unathorised.
 
2019-05-22 00:11:35.4527|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001283| RequestID = s_6a077791-e4b6-4df6-b500-43388022ec3f
2019-05-22 00:11:51.3842|INFO|39|Received request GET | RequestID = s_bd226fee-61d0-4053-8cc6-57c312b2f743
2019-05-22 00:11:57.0293|INFO|40|Received request GET /api/v2.0/ServiceState| RequestID = s_dd68be34-263b-4cfa-990f-b02ccfc1814d
2019-05-22 00:11:57.0293|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001742| RequestID = s_dd68be34-263b-4cfa-990f-b02ccfc1814d
2019-05-22 00:11:57.2474|INFO|40|Received request GET /api/v2.0/ServiceState| RequestID = s_be9aeee1-19b2-4411-84e8-457d8f0e38fb
2019-05-22 00:11:57.2474|INFO|40|Sending response. Response code 401, Elapsed time 0:00:00.0001366| RequestID = s_be9aeee1-19b2-4411-84e8-457d8f0e38fb
2019-05-22 00:18:16.8672|INFO|42|Received request GET /api/v2.0/ServiceState| RequestID = s_0ef6cbe1-2aaa-4eef-bb5b-09d6e690b82c
2019-05-22 00:18:16.8672|INFO|42|Sending response. Response code 401, Elapsed time 0:00:00.0002326| RequestID = s_0ef6cbe1-2aaa-4eef-bb5b-09d6e690b82c

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

d_gosbell — Wed, 22 May 2019 06:48:56 GMT

It's probably something in your custom authentication.

How does your custom authentication work?

What happens when you attempt to hit one of the urls PBI desktop is attempting to connect to like http://<servername>/reports/api/v2.0/ServiceState Does it return a json response or a 401 error or does it prompt for a username and password?

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

Anonymous — Wed, 22 May 2019 08:13:27 GMT

Hi,

Thank you for the reply. After using the API service state url I am getting a pop up window to enter user id and password. Once I enetered the credentials I get the below error message.

This page isn’t working

If the problem continues, contact the site owner.

HTTP ERROR 401

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

d_gosbell — Wed, 22 May 2019 11:01:42 GMT

Anonymous wrote:
Hi,

Thank you for the reply. After using the API service state url I am getting a pop up window to enter user id and password. Once I enetered the credentials I get the below error message.
This page isn’t working
If the problem continues, contact the site owner.
HTTP ERROR 401

So I can think of 2 possible issues here. One is that I'm not sure if Power BI Desktop will have the facility to be able to trigger an authentication pop up. The second is that there seems to be some other issue even when you do enter the credentials.

Can try temporarily switching back to Windows auth? This will allow you to confirm that this API is working properly in your environment. If you can confirm that this api call works without your custom authentication then we know definitively that this is the issue and then you'll need to debug the code for the custom auth to figure out the issue.

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

Anonymous — Mon, 19 Aug 2019 08:45:16 GMT

The problem was in the code itself in the logon page of the custom authentication. Thank you for the suggestions, it helped me on my solution.

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

torontow — Fri, 21 Feb 2020 19:28:14 GMT

I have exactly the same error, when typing "http://<servername>/reports/api/v2.0/ServiceState" you suggested I got a JSON response. What does this mean?

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

Anonymous — Thu, 12 Mar 2020 17:43:21 GMT

Hi,

Just wondering if you managed to find a solution to this issue?

Re: Unexpected Error Power BI report Server With Desktop While Connecting/Save As

hellodfkh — Sat, 02 Mar 2024 10:14:41 GMT

Hi, where in exactly you found the error? I have also implemented a custom authentication measure but I do not know where is the error coming from.

Appreciate the help!