Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I try to use Power BI ReportServer in LAN.
Everything goes well except when I open the report on ReportServer there always prompt a login page。
So how can I remove it?Hard code the username\pass in somewhere?
Solved! Go to Solution.
Solution for the exception that is taken for power Bi reports while using custom security extension :
*****************************************
2017-08-03 11:35:16.8710|ERROR|90|Failure in conceptualschema| RequestID = 5a55046e-0305-361b-e214-71fd8b0d79ff ClientSessionID = 3aee7b14-c24b-d6ac-237d-38809550b1bb System.NotSupportedException: PortalIdentity is not supported.
at Microsoft.PowerBI.ReportServer.ExploreHost.UserIdentityConnectionImpersonatorFactory.CreateImpersonator(IIdentity identity)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelInfo(String id)
***********************
The data source attempting to use integrated security which is not supported with custom Auth. If you edit the data source for the report and use stored credentials it should work.
Hi @wildcatstar
Maybe I got it wrong due to many development answers, but did you tried just to add your site on the local intranet on Internet Properties screen?
It could be an problem regarding to NTLM on you LAN. If you windows, for any reason, don't reconizes that it is a LAN address, it is going to ask for auth (so far as I know)
Hello,
Did you resolve this issue ? Any documentation ?
Much Appreciated,
Hi Laith,
We are also facing same issue.
Did you resolve this issue ? Any documentation ?
Much Appreciated,
Hi @wildcatstar,
Yes, I meant to do that on all user computers, OR don't use IP address to access the reports, OR don't use FQDN.
I think that if you change the Authentication method, maybe you will fall in problems with SSAS connections, because SSAS accept only Windows Authentication (NTLM (default) if in the same SSRS machine or Kerberos if SSAS is in a remote server)
Please, read this article: https://support.microsoft.com/en-us/help/303650/intranet-site-is-identified-as-an-internet-site-when...
Hi @muchinski,
I have read the artile, and I don't think it is a proper solution to require user to change the IE config.
In that way, maybe input username and password is more easier.
If custom auth is not supportted by SSAS connection, may be I have to wait until the report server support embed data,
just like excel,etc.
Hi @wildcatstar,
I am not telling that it is not supported, you could just use a fixed user in a SSAS connection and that’s ok, but usually we use Windows Authentication. Also, you would need to validate it before every update, which for me is not a good deal.
Anyway, just to clarify (I just tested - and it is the same that the article said): It will ask for authentication if I access the reports using:
-- FQDN - http://inhouse-rep1.<MyDomain>.de/Reports
-- IP - http://50.52.41.23/Reports
But if I access using a URL like the following or add the site on Local Intranet, windows authentication works as expected (at least for me)
-- http://inhouse-rep1/Reports
I hope to have helped 🙂
Hi @wildcatstar,
On the Report Server Configuration Manager, create one URL for you Web Service URL and Web Portal URL choosing 'All Assigned' instead of choosing your IP.
By default, it will create one address with the name of your server. You can also create a CNAME (DNS) on AD and use it if you want to.
Which login page are you seeing, is it the browser pop-up which prompts for Domain credentials or is it something else? Which Authentication Type is your report server using, I assume windows.?
Hi,
Is there any solution to remove auth window?
Hi @wildcatstar, Report Server will require user context for both secuirty and access control needs. That's why you have to setup one Auth method to use the server. However, if you are really sure to remove the auth, there's one workaround that you can implement your own custom auth extension, just return true for each auth request. You can find custom auth example in githut: https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample
Hi @shiboli ,At last I copy Microsoft.Samples.ReportingServices.CustomSecurity.dll in both PowerBI and ReportServer\bin folders, I can successfully save a report to Report Server from desktop.
But when I open the report on the server in IE, it got another error.Here is the logs:
---------------------------------------------------------------------
2017-07-25 23:13:53.1729|INFO|15|Received request administrator RequestID = 7b474824-2dc3-d120-acfe-cdeb0f0ac9eb ClientSessionID = faed8e08-4209-3766-f043-507137a53316 2017-07-25 23:13:53.2989|ERROR|14|
Failure in conceptualschema| RequestID = 7b474824-2dc3-d120-acfe-cdeb0f0ac9eb ClientSessionID = faed8e08-4209-3766-f043-507137a53316 System.NotSupportedException: PortalIdentity is not supported.
在 Microsoft.PowerBI.ReportServer.ExploreHost.UserIdentityConnectionImpersonatorFactory.CreateImpersonator(IIdentity identity) 在 Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelInfo(String id)
------------------------------------------------------------
So what is "System.NotSupportedException: PortalIdentity is not supported" mean? How could I do to solve it?
public void GetUserInfo(out IIdentity userIdentity, out IntPtr userId)
{
userIdentity = new GenericIdentity("administrator");
// initialize a pointer to the current user id to zero
userId = IntPtr.Zero;
}
It seems GenericIdentity is not a WindowIdentity, so a NotSupportedException throwed.
I already defined impersonate = false in web.config.
But what kind of icIdentity should I return?return WindowIdentity("administrator") doesn't work.
Solution for the exception that is taken for power Bi reports while using custom security extension :
*****************************************
2017-08-03 11:35:16.8710|ERROR|90|Failure in conceptualschema| RequestID = 5a55046e-0305-361b-e214-71fd8b0d79ff ClientSessionID = 3aee7b14-c24b-d6ac-237d-38809550b1bb System.NotSupportedException: PortalIdentity is not supported.
at Microsoft.PowerBI.ReportServer.ExploreHost.UserIdentityConnectionImpersonatorFactory.CreateImpersonator(IIdentity identity)
at Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelInfo(String id)
***********************
The data source attempting to use integrated security which is not supported with custom Auth. If you edit the data source for the report and use stored credentials it should work.
Hi @asogukpinar,
You're right, it works. Thank you.
It has to be a real WindowsIdentity who can access to your AS server that your pbi report users. If you want everybody to use the user who's runinng the report server to make the connection, just return WindowsIdentity.GetCurrent()(https://msdn.microsoft.com/en-us/library/sfs49sw0(v=vs.110).aspx).
But again, doing this will make all users to use same identity, which may have permission/security issues you may have to resolve in the future.
Hi @shiboli, thank you.
I have changed GetUserInfo to use WindowsIdentity.GetCurrent().
But it still has the error:
------------------------------------------------
Failure in conceptualschema| RequestID = 7b474824-2dc3-d120-acfe-cdeb0f0ac9eb ClientSessionID = faed8e08-4209-3766-f043-507137a53316
System.NotSupportedException: PortalIdentity is not supported. 在 Microsoft.PowerBI.ReportServer.ExploreHost.UserIdentityConnectionImpersonatorFactory.CreateImpersonator(IIdentity identity) 在 Microsoft.PowerBI.ReportServer.ExploreHost.RSPowerViewHandler.GetModelInfo(String id)
-----------------------------------------------------
I dont know why I returned WindowsIdentity.GetCurrent()
but at CreateImpersonator method it changed to a PortalIdentity?
Hi @shiboli, Thank you very much for your help.
I followed the step in https://github.com/Microsoft/Reporting-Services/tree/master/CustomSecuritySample .
I modified the GetUserInfo function like this:
And at last, I can login in as "Administrator" with out the auth page.
It seems the GetUserInfo method worked.
But when I try to save a report to the Server,I got an error dialog:
And I find the error log:
I don't know why GetUserInfo will get a null reference error.
By the way,I didn't Generate Machine Keys and Configure Passthrough cookies, Because I return true in each request method.
Is there something wrong?
Yes you're right.
Every time I opened the server in IE and will get this window:
And I need to input windows username and password to login.
I want to remove the windows auth page, but I don not want to add a custom login page too.
I hope the report on this server allow every one to open and view easily, no need to login at all,
So how can I do to implement it?
Thanks.