cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wildcatstar Regular Visitor
Regular Visitor

How can I remove auth page when open Report Server page?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
asogukpinar Visitor
Visitor

Re: How can I remove auth page when open Report Server page?

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.

 

silll.jpg

View solution in original post

19 REPLIES 19
Power BI Team mgmeyer
Power BI Team

Re: How can I remove auth page when open Report Server page?

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

wildcatstar Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

Yes you're right.

Every time I opened the server in IE and will get this window:

无标题.png

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.

wildcatstar Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

Hi,

    Is there any solution to remove auth window?

shiboli Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

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 

wildcatstar Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

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:

001.png

And at last, I can login in as "Administrator" with out the auth page.

002.png

 

It seems the GetUserInfo method worked.

 

But when I try to save a report to the Server,I got an error dialog:

003.png

And I find the  error log:

 

004.png

 

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?

 

wildcatstar Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

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.

shiboli Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

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. 

 

wildcatstar Regular Visitor
Regular Visitor

Re: How can I remove auth page when open Report Server page?

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?

muchinski Member
Member

Re: How can I remove auth page when open Report Server page?

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)

 

Local Intranet.JPG

Helpful resources

Announcements
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 Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

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.

Users Online
Currently online: 213 members 2,140 guests
Please welcome our newest community members: