cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

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

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
1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

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

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.

View solution in original post

4 REPLIES 4
Super User
Super User

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

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?

Anonymous
Not applicable

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

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
Super User
Super User

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


@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. 

Anonymous
Not applicable

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

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.

View solution in original post

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 408 members 3,882 guests
Please welcome our newest community members: