topic Re: Users are getting authentication prompt then Error 401 when using edge with work server in Report Server

Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Thu, 14 Apr 2022 15:55:25 GMT

We have tried with a few different users and all have the same repeated prompts for credentials. I have tried all combinations with/without UPN or DOMAIN etc and just get repeated prompt, clicking cancel gives error 401.

I have cleared all cache/cookies

I have tried inprivate browsing

I have tried rebooting my machine

I have added to trusted sites (even though its a domain server)

This has affected every person we have tried with but only on Edge. Chrome works fine with no authentication prompt.

Any help greatly appreciated!

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Coolew01 — Thu, 14 Apr 2022 20:47:30 GMT

I am having a similar issue in both browsers. It keeps asking for my credentials and then doesn't login. it prompts me repeatedly.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Icey — Tue, 19 Apr 2022 06:52:33 GMT

Hi Anonymous ,

What's the version of your Power BI Report Server and Microsoft Edge?

Does it work previously? When does this issue start to appear?

Best Regards,

Icey

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Tue, 19 Apr 2022 07:03:32 GMT

Morning Icey, thanks for the response.

Its powerBI report server 15.0.2.557

I am not sure if Edge was used before successfully but I can only assume it has been, the issue was reported last week by users and we have tested on multiple machines in IT since, all windows 10. I have tried with edge ver 99.xxx and the latest which was 100.xx.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Icey — Tue, 19 Apr 2022 09:43:26 GMT

Hi Anonymous ,

So you are using August 2018, which released on August 30, 2018. It's a very old version. Give me some time to test.

In addition, you might be able to try another newer version: Change log for Power BI Report Server - Power BI | Microsoft Docs.

Best Regards,

Icey

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Wed, 20 Apr 2022 07:40:58 GMT

Thank you Icey, I look forward to your test results. For the upgrade, do you know if upgrading the work server to January 2022 release will affect any of the older PowerBI reports? We currently have the workaround (use Chrome) so I have some time to find a fix. I worry that upgrading the work server could cause other issues.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Icey — Fri, 22 Apr 2022 07:53:20 GMT

Hi Anonymous ,

I have tested with PBIRS Aug 2018. But it works well. Maybe you can check the log of PBIRS at C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles.

Reference: Reporting Services Log Files and Sources - SQL Server Reporting Services (SSRS) | Microsoft Docs

Or you can try to uninstall plugins and reset Edge to see if it is caused by the custom setting of Edge.

And for upgrading PBIRS, to my knowledge, it won't affect the older Power BI Reports.

But there is one thing to note that the models are with enhanced metadata from Oct 2020. And when you are using Jan 2022 PBIRS, it would be better to create your reports based on the corresponding version of PBI Desktop (optimized for Power BI Report Server).

Before you upgrade a report server, we recommend the following steps to back up your report server.

1. Backing up the encryption keys

2. Backing up the report server databases

3. Backing up the configuration files

Reference: Upgrade Power BI Report Server - Power BI | Microsoft Docs

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Mon, 25 Apr 2022 18:34:18 GMT

Hi Icey,

Ok so I bit the bullet and took a snapshot of the server and DB backups prior. I am now on Jan2022 version. Unfortunately the issue persists and only with Edge. I have tried from multiple machines INCLUDING clearing all cookies and resetting edge to defaults but still get repeatedly prompted for authentication and eventually a 401 error. Any other ideas? Specifically, which logs should I check out? I have them ordered by date/time stamp and the latest ones dont show login errors...

At least so far we are on a newer version 🙂

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Icey — Tue, 26 Apr 2022 09:38:37 GMT

Hi Anonymous ,

You can check the log file named "RSPortal_xxx.log".

And you can also catch the browser trace with F12->Network. For detailed steps, please check: Collect a browser trace.

Note: For your data security, please don't share your logs here directly.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Mon, 16 May 2022 17:12:45 GMT

Hi Icey, RSPortal has not updated since 16/05 and doesnt update no matter how many times I have the failed attempts. Here is the log file from the network trace in dev tools. I have changed server name and IP. I can only see one discrepancy and that is that it seems to think it is on GMT when we are currently in BST so there is a 1-hour difference in the timestamps BUT on the PoswerBI work server the time is correct and matches my workstation. The other error I see under network is {Failed to load response data: No resources with given identifier found}

Any more pointers? My users are starting to get 'Edgy' 🙂

{
"log": {
"version": "1.2",
"creator": {
"name": "WebInspector",
"version": "537.36"
},
"pages": [],
"entries": [
{
"_initiator": {
"type": "other"
},
"_priority": "VeryHigh",
"_resourceType": "document",
"cache": {},
"connection": "1430",
"request": {
"method": "GET",
"url": "http://mypowerbiserver/Reports/browse",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Accept",
"value": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9"
},
{
"name": "Accept-Encoding",
"value": "gzip, deflate"
},
{
"name": "Accept-Language",
"value": "en-GB,en;q=0.9,en-US;q=0.8"
},
{
"name": "Connection",
"value": "keep-alive"
},
{
"name": "Host",
"value": "mypowerbiserver"
},
{
"name": "Upgrade-Insecure-Requests",
"value": "1"
},
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36 Edg/100.0.1185.39"
}
],
"queryString": [],
"cookies": [],
"headersSize": 465,
"bodySize": 0
},
"response": {
"status": 401,
"statusText": "Unauthorized",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Content-Length",
"value": "0"
},
{
"name": "Date",
"value": "Mon, 16 May 2022 16:53:20 GMT"
},
{
"name": "Server",
"value": "Microsoft-HTTPAPI/2.0"
},
{
"name": "WWW-Authenticate",
"value": "Negotiate"
},
{
"name": "WWW-Authenticate",
"value": "NTLM"
}
],
"cookies": [],
"content": {
"size": 0,
"mimeType": "text/plain",
"compression": -817
},
"redirectURL": "",
"headersSize": 169,
"bodySize": 817,
"_transferSize": 986,
"_error": "net::ERR_INVALID_AUTH_CREDENTIALS"
},
"serverIPAddress": "1.202.203.204",
"startedDateTime": "2022-05-16T16:53:19.694Z",
"time": 68.21300002047792,
"timings": {
"blocked": 64.38000000484473,
"dns": -1,
"ssl": -1,
"connect": -1,
"send": 0.0870000000000033,
"wait": 1.1969999894406627,
"receive": 2.549000026192516,
"_blocked_queueing": 15.10200000484474,
"_blocked_proxy": 0.24800000000000022
}
},
{
"_initiator": {
"type": "other"
},
"_priority": "VeryHigh",
"_resourceType": "document",
"cache": {},
"connection": "1430",
"request": {
"method": "GET",
"url": "http://mypowerbiserver/Reports/browse",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Accept",
"value": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9"
},
{
"name": "Accept-Encoding",
"value": "gzip, deflate"
},
{
"name": "Accept-Language",
"value": "en-GB,en;q=0.9,en-US;q=0.8"
},
{
"name": "Cache-Control",
"value": "max-age=0"
},
{
"name": "Connection",
"value": "keep-alive"
},
{
"name": "Host",
"value": "mypowerbiserver"
},
{
"name": "Upgrade-Insecure-Requests",
"value": "1"
},
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36 Edg/100.0.1185.39"
}
],
"queryString": [],
"cookies": [],
"headersSize": 491,
"bodySize": 0
},
"response": {
"status": 401,
"statusText": "Unauthorized",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Content-Length",
"value": "0"
},
{
"name": "Date",
"value": "Mon, 16 May 2022 16:53:29 GMT"
},
{
"name": "Server",
"value": "Microsoft-HTTPAPI/2.0"
},
{
"name": "WWW-Authenticate",
"value": "Negotiate"
},
{
"name": "WWW-Authenticate",
"value": "NTLM"
}
],
"cookies": [],
"content": {
"size": 0,
"mimeType": "text/plain",
"compression": -1634
},
"redirectURL": "",
"headersSize": 169,
"bodySize": 1634,
"_transferSize": 1803,
"_error": "net::ERR_INVALID_AUTH_CREDENTIALS"
},
"serverIPAddress": "1.202.203.204",
"startedDateTime": "2022-05-16T16:53:29.008Z",
"time": 90.42900000349618,
"timings": {
"blocked": 88.24500000658072,
"dns": -1,
"ssl": -1,
"connect": -1,
"send": 0.05700000000000216,
"wait": 0.3799999948460595,
"receive": 1.7470000020693988,
"_blocked_queueing": 1.2660000065807253,
"_blocked_proxy": 0.23199999999999932
}
},
{
"_initiator": {
"type": "other"
},
"_priority": "VeryHigh",
"_resourceType": "document",
"cache": {},
"connection": "1430",
"request": {
"method": "GET",
"url": "http://mypowerbiserver/Reports/browse",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Accept",
"value": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.9"
},
{
"name": "Accept-Encoding",
"value": "gzip, deflate"
},
{
"name": "Accept-Language",
"value": "en-GB,en;q=0.9,en-US;q=0.8"
},
{
"name": "Cache-Control",
"value": "max-age=0"
},
{
"name": "Connection",
"value": "keep-alive"
},
{
"name": "Host",
"value": "mypowerbiserver"
},
{
"name": "Upgrade-Insecure-Requests",
"value": "1"
},
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36 Edg/100.0.1185.39"
}
],
"queryString": [],
"cookies": [],
"headersSize": 491,
"bodySize": 0
},
"response": {
"status": 401,
"statusText": "Unauthorized",
"httpVersion": "HTTP/1.1",
"headers": [
{
"name": "Content-Length",
"value": "0"
},
{
"name": "Date",
"value": "Mon, 16 May 2022 16:53:34 GMT"
},
{
"name": "Server",
"value": "Microsoft-HTTPAPI/2.0"
},
{
"name": "WWW-Authenticate",
"value": "Negotiate"
},
{
"name": "WWW-Authenticate",
"value": "NTLM"
}
],
"cookies": [],
"content": {
"size": 0,
"mimeType": "text/plain",
"compression": -817
},
"redirectURL": "",
"headersSize": 169,
"bodySize": 817,
"_transferSize": 986,
"_error": "net::ERR_HTTP_RESPONSE_CODE_FAILURE"
},
"serverIPAddress": "1.202.203.204",
"startedDateTime": "2022-05-16T16:53:34.497Z",
"time": 34.266000002389774,
"timings": {
"blocked": 27.426000014692544,
"dns": -1,
"ssl": -1,
"connect": -1,
"send": 0.06400000000000006,
"wait": 4.111000009546057,
"receive": 2.6649999781511724,
"_blocked_queueing": 2.601000014692545,
"_blocked_proxy": 0.28000000000000025
}
}
]
}
}

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Thu, 19 May 2022 14:22:32 GMT

Does Icey or anybody else have any suggestions on what I can do please?

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Tue, 12 Jul 2022 09:46:15 GMT

I have not heard anything back on this. I may have to log it with Microsoft.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Anonymous — Sat, 19 Nov 2022 05:12:32 GMT

Please let me know if you find a solution. I have as yet found nothing and this forum has been a dead end.

Re: Users are getting authentication prompt then Error 401 when using edge with work server

Coolew01 — Mon, 21 Nov 2022 17:12:02 GMT

The work around has been to access the web browswer through Citrix rather than the computer's browser.